VIEW: APPS.PQH_ATTRIBUTE_RANGES_V4

Source

View Text - Preformatted

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_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.enable_flag enable_flag FROM pqh_attribute_ranges RNG, pqh_routing_list_members_v RLM WHERE RNG.attribute_id IS NOT 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 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_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.ENABLE_FLAG ENABLE_FLAG
FROM PQH_ATTRIBUTE_RANGES RNG
, PQH_ROUTING_LIST_MEMBERS_V RLM
WHERE RNG.ATTRIBUTE_ID IS NOT 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(+)