GL Other - Data Access Set Listing
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- Other - Data Access Set Listing (XML)
- Short Name
- GLXDALST_XML
- DB package
- GL_GLXDALST_XMLP_PKG
SQL 10 lines
select an.ledger_id LEDGER_ID, l.name LEDGER_NAME, lp.meaning LEDGER_TYPE , an.all_segment_value_flag ALL_SEGMENT_VALUE_FLAG, an.access_privilege_code ACCESS_PRIVILEGE_CODE, an.segment_value SESGMENT_VALUE from gl_access_set_norm_assign an, gl_ledgers l, gl_lookups lp where an.access_set_id = :P_ACCESS_SET_ID and l.ledger_id = an.ledger_id and lp.lookup_type = 'LEDGERS' and lp.lookup_code = l.object_type_code order by l.name, an.segment_value |
Parameters 1
| Parameter | Type | List of values SQL |
|---|---|---|
| Data Access Set | LOV Oracle |