GL Other - Definition Access Set Listing
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- Other - Definition Access Set Listing (XML)
- Short Name
- GLXDFLST_XML
- DB package
- GL_GLXDFLST_XMLP_PKG
SQL 10 lines
select object_description DEFINITION_TYPE, object_name DEFINITION_NAME, decode(use_access_flag, 'Y', 'X', null) USE_PRIVILEGE, decode(view_access_flag, 'Y', 'X', null) VIEW_PRIVILEGE, decode(modify_access_flag, 'Y', 'X', null) MODIFY_PRIVILEGE from gl_defas_assignments_v where definition_access_set_id = :P_DEFAS_ID and object_type = nvl(:P_DEFINITION_TYPE, object_type) order by DEFINITION_TYPE, DEFINITION_NAME |
Parameters 2
| Parameter | Type | List of values SQL |
|---|---|---|
| Definition Access Set | LOV Oracle | |
| Definition Type | LOV Oracle |