GL Other - Definition Access By User

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Other - Definition Access By User (XML)
Short Name: GLXDFUSR_XML
DB package: GL_GLXDFUSR_XMLP_PKG
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
Definition Type
 
LOV Oracle
User Name
 
LOV Oracle
Ask a question