[Home] [Help]
View: PQH_ATTRIBUTE_RANGES_V2
View Text
SELECT DISTINCT RNG.ROUTING_CATEGORY_ID ROUTING_CATEGORY_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
, NVL(RNG.DELETE_FLAG
, 'N') DELETE_FLAG
FROM PQH_ATTRIBUTE_RANGES RNG
, PQH_ROUTING_LIST_MEMBERS_V RLM
WHERE (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 |
ROUTING_MEMBER_ID |
ROUTING_MEMBER_NAME |
RANGE_NAME |
APPROVER_FLAG |
ENABLE_FLAG |
DELETE_FLAG |