View: AHL_APPROVERS_V

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

View Text

SELECT DISTINCT AA.ROWID ROW_ID
, AA.APPROVAL_APPROVER_ID
, AA.APPROVAL_RULE_ID
, AA.OBJECT_VERSION_NUMBER
, AA.APPROVER_TYPE_CODE
, FNDA.MEANING APPROVER_TYPE_NAME
, AA.APPROVER_ID
, JRREV.USER_NAME APPROVER_NAME
, AA.APPROVER_SEQUENCE
FROM AHL_APPROVERS AA
, FND_LOOKUP_VALUES_VL FNDA
, AHL_JTF_RS_EMP_V JRREV
WHERE FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
AND FNDA.LOOKUP_CODE = 'USER'
AND AA.APPROVER_TYPE_CODE = 'USER'
AND AA.APPROVER_ID = JRREV.RESOURCE_ID UNION (SELECT DISTINCT AA.ROWID ROW_ID
, AA.APPROVAL_APPROVER_ID
, AA.APPROVAL_RULE_ID
, AA.OBJECT_VERSION_NUMBER
, AA.APPROVER_TYPE_CODE
, FNDA.MEANING APPROVER_TYPE_NAME
, AA.APPROVER_ID
, JRRV.ROLE_NAME APPROVER_NAME
, AA.APPROVER_SEQUENCE
FROM AHL_APPROVERS AA
, FND_LOOKUP_VALUES_VL FNDA
, JTF_RS_ROLE_RELATIONS_VL JRRV
WHERE FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
AND FNDA.LOOKUP_CODE = 'ROLE'
AND AA.APPROVER_TYPE_CODE = 'ROLE'
AND AA.APPROVER_ID = JRRV.ROLE_ID) UNION (SELECT DISTINCT AA.ROWID ROW_ID
, AA.APPROVAL_APPROVER_ID
, AA.APPROVAL_RULE_ID
, AA.OBJECT_VERSION_NUMBER
, AA.APPROVER_TYPE_CODE
, FNDA.MEANING APPROVER_TYPE_NAME
, AA.APPROVER_ID
, '' APPROVER_NAME
, AA.APPROVER_SEQUENCE
FROM AHL_APPROVERS AA
, FND_LOOKUP_VALUES_VL FNDA
WHERE FNDA.LOOKUP_TYPE = 'AHL_APPROVER_TYPE'
AND FNDA.LOOKUP_CODE = 'ROLE'
AND AA.APPROVER_TYPE_CODE = 'ROLE'
AND AA.APPROVER_ID IS NULL)

Columns