[Home] [Help]
View: PQH_ATTRIBUTE_RANGES_V3
View Text
SELECT RNG.ROUTING_CATEGORY_ID ROUTING_CATEGORY_ID
, RNG.ATTRIBUTE_RANGE_ID ATTRIBUTE_RANGE_ID
, RNG.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RNG.ATTRIBUTE_ID ATTRIBUTE_ID
, DECODE(RNG.ROUTING_LIST_MEMBER_ID
, NULL
, DECODE(RNG.POSITION_ID
, NULL
, RNG.ASSIGNMENT_ID
, RNG.POSITION_ID)
, RNG.ROUTING_LIST_MEMBER_ID) ROUTING_MEMBER_ID
, DECODE(RNG.ROUTING_LIST_MEMBER_ID
, NULL
, DECODE( RNG.POSITION_ID
, NULL
, PQH_UTILITY.DECODE_ASSIGNMENT_NAME(RNG.ASSIGNMENT_ID)
, HR_GENERAL.DECODE_POSITION(RNG.POSITION_ID))
, DECODE(RLM.USER_ID
, NULL
, RLM.ROLE_NAME
, RLM.ROLE_NAME||' - '||RLM.USER_NAME)) ROUTING_MEMBER_NAME
, RNG.RANGE_NAME RANGE_NAME
, RNG.APPROVER_FLAG APPROVER_FLAG
, RNG.ENABLE_FLAG ENABLE_FLAG
FROM PQH_ATTRIBUTE_RANGES RNG
, PQH_ROUTING_LIST_MEMBERS_V RLM
WHERE RNG.ATTRIBUTE_ID IS NULL
AND (RNG.ROUTING_LIST_MEMBER_ID IS NOT NULL OR RNG.POSITION_ID IS NOT NULL OR RNG.ASSIGNMENT_ID IS NOT NULL)
AND RNG.ROUTING_LIST_MEMBER_ID = RLM.ROUTING_LIST_MEMBER_ID(+)
Columns
Name |
ROUTING_CATEGORY_ID |
ATTRIBUTE_RANGE_ID |
OBJECT_VERSION_NUMBER |
ATTRIBUTE_ID |
ROUTING_MEMBER_ID |
ROUTING_MEMBER_NAME |
RANGE_NAME |
APPROVER_FLAG |
ENABLE_FLAG |