GL Other - Definition Access Set Listing

➜ Back to Library
Description
Categories: BI Publisher
Application: General Ledger
Source: Other - Definition Access Set Listing (XML)
Short Name: GLXDFLST_XML
DB package: GL_GLXDFLST_XMLP_PKG
Run GL Other - Definition Access Set Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
GL Other - Definition Access By User AR Customers and Sites ONT Orders and Lines PER Employee Assignments CAC Calculate ICP PII Item Costs GL Budget - Organization Listing CAC Intercompany SO Price List vs. Item Cost Comparison ECC Projects, Projects Costing: Transactions, SQL1 AP Accounted Invoice Aging
Blitz Report™

Blitz Report™ provides multiple benefits: