Oracle ERP R12表结构

select t.security_profile_id from PER_SECURITY_PROFILES_V t where t.security_pro

select * from PER_SECURITY_ORGANIZATIONS_V t where t.security_profile_id=5062;

SELECT '6' TYPE,

'采购' source_system,

hou.short_code,

https://www.360docs.net/doc/f3713509.html,,

gse.period_name,

alc.description

FROM ap_lookup_codes alc,

gl_period_statuses gse,

hr_operating_units hou,

gl_ledgers gl

WHERE gse.closing_status = alc.lookup_code

AND alc.lookup_type = 'CLOSING STATUS'

AND gse.adjustment_period_flag = 'N'

AND gse.period_name = p_period_name

AND gse.application_id = 201

AND gse.set_of_books_id =hou.set_of_books_id

AND gl.ledger_id = gse.set_of_books_id

AND gl.ledger_id = p_ledger_id

AND mo_global.check_access(https://www.360docs.net/doc/f3713509.html,anization_id) = 'Y'--HRMS安全性配置文件

security_profile_name='C11005293_中国邮储银行总行'; profile_id=5062;

全性配置文件