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
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 NameSQL textValidation
Definition Access Set
 
LOV Oracle
Definition Type
 
LOV Oracle
Download
Related Blitz Reports
GL Other - Definition Access By User ECC Projects, Projects Costing: Transactions, SQL1 AR Customers and Sites AJ: AR Customers and Sites TB Accounts Payables Trial Balance - FSSC CAC Inventory Organization Summary COPY OF: AP Accounted Invoice Aging GL Budget Amounts Upload TB GL Account Analysis (Drilldown)v2
Blitz Report™