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,

http://www.doczj.com/doc/f0933233240c844768eaeed3.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