[Home] [Help]
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
Name |
ROW_ID |
APPROVAL_APPROVER_ID |
APPROVAL_RULE_ID |
OBJECT_VERSION_NUMBER |
APPROVER_TYPE_CODE |
APPROVER_TYPE_NAME |
APPROVER_ID |
APPROVER_NAME |
APPROVER_SEQUENCE |