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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
Parameter Name SQL text Validation
Definition Access Set
 
LOV Oracle
Definition Type
 
LOV Oracle