GL Other - Definition Access By User

➜ Back to Library
Description
Categories: BI Publisher
Application: General Ledger
Source: Other - Definition Access By User (XML)
Short Name: GLXDFUSR_XML
DB package: GL_GLXDFUSR_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 &NAME_COLUMN DEFINITION_NAME,
       MAX(decode(FGV.FUNCTION_NAME, FGV.OBJ_NAME || '_U', 'X', NULL )) USE_PRIVILEGE,
       MAX(decode(FGV.FUNCTION_NAME, FGV.OBJ_NAME || '_V', 'X', NULL )) VIEW_PRIVILEGE,
       MAX(decode(FGV.FUNCTION_NAME, FGV.OBJ_NAME || '_M', 'X', NULL )) MODIFY_PRIVILEGE
FROM &TABLE_NAME DEF,
     FND_GRANTS_VIEW FGV
&WHERE_DEFAS
AND FGV.user_name = :P_USER_NAME
AND FGV.OBJ_NAME = :P_DEFINITION_TYPE
AND FGV.INSTANCE_PK1_VALUE = &ID_COLUMN1
AND FGV.INSTANCE_PK2_VALUE = '*NULL*'
AND FGV.INSTANCE_PK3_VALUE = '*NULL*'
AND FGV.INSTANCE_PK4_VALUE = '*NULL*'
AND FGV.INSTANCE_PK5_VALUE = '*NULL*'
GROUP BY &NAME_COLUMN
ORDER BY DEFINITION_NAME
Parameter Name SQL text Validation
User Name 
 
 LOV Oracle
Definition Type 
 
 LOV Oracle
Download
 
Related Blitz Reports
GL Account Analysis INV Intercompany Invoice Reconciliation Blitz Report VPD Policy Setup MRP Sourcing Rule Upload COPY OF: GL Balance XXFT GL Balance CAC Receiving Account Detail GL Balance by Account Hierarchy Mrugesh: GL Balance
Blitz Report™

Blitz Report™ provides multiple benefits: