VIEW: APPS.AHL_APPROVERS_V

Source

View Text - Preformatted

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 = AA.APPROVER_TYPE_CODE 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 = AA.APPROVER_TYPE_CODE AND AA.APPROVER_TYPE_CODE = 'ROLE' AND (AA.APPROVER_ID = JRRV.ROLE_ID OR AA.approver_id is null)

View Text - HTML Formatted

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 = AA.APPROVER_TYPE_CODE
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 = AA.APPROVER_TYPE_CODE
AND AA.APPROVER_TYPE_CODE = 'ROLE'
AND (AA.APPROVER_ID = JRRV.ROLE_ID OR AA.APPROVER_ID IS NULL)