VIEW: APPS.PQH_ATTRIBUTE_RANGES_V3

Source

View Text - Preformatted

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_tct_wizard_pkg.return_person_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(+)

View Text - HTML Formatted

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_TCT_WIZARD_PKG.RETURN_PERSON_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(+)