GL Other - Definition Access By User

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