Oracle Fusion Apps – GL Ledger Access Set Query

select gasl.access_set_id , gas.name access_set_name,
gasl.LEDGER_ID, gl.name ledger_name , gl.description, gl.LEDGER_CATEGORY_CODE,
gl.CURRENCY_CODE, gl.PERIOD_SET_NAME 
 from gl_access_sets gas , gl_access_set_ledgers  gasl , gl_ledgers gl 
where 1=1
and gas.access_set_id = gasl.access_set_id  
and gl.ledger_id = gasl.ledger_id 
order by gl.creation_date desc 

Leave a Reply

Your email address will not be published.