View: AHL_APPROVERS_TYPE_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view stores the query relates to approver types information
Implementation/DBA Data:	APPS.AHL_APPROVERS_TYPE_V

View Text

SELECT DISTINCT JRRR.ROLE_ID
, JRRV.ROLE_NAME
, FNDA.LOOKUP_CODE
FROM JTF_RS_ROLE_RELATIONS JRRR
, JTF_RS_ROLES_VL JRRV
, FND_LOOKUP_VALUES_VL FNDA
WHERE JRRV.ROLE_TYPE_CODE IN ('AHLAPPR'
, 'AHLGAPPR')
AND FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
AND FNDA.LOOKUP_CODE = 'ROLE'
AND JRRR.ROLE_ID = JRRV.ROLE_ID UNION SELECT DISTINCT AJREV.RESOURCE_ID
, AJREV.USER_NAME
, FNDA.LOOKUP_CODE
FROM AHL_JTF_RS_EMP_V AJREV
, FND_LOOKUP_VALUES_VL FNDA
WHERE FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
AND FNDA.LOOKUP_CODE = 'USER'

Columns