VIEW: APPS.PQH_ROUTING_CATEGORIES_V

Source

View Text - Preformatted

SELECT RCT.routing_category_id , RCT.transaction_category_id , RCT.enable_flag, RCT.default_flag, RCT.delete_flag, decode(RCT.routing_list_id,NULL,decode( RCT.Position_structure_id,NULL,'S','P'),'R') member_cd, decode(RCT.routing_list_id,NULL,decode( RCT.Position_structure_id,NULL,NULL,RCT.position_structure_id),RCT.routing_list_id) list_id, decode(RCT.routing_list_id,NULL,decode( RCT.position_structure_id,NULL,hr_general.decode_lookup( 'PQH_SUPERVISORY_HIERARCHY','SUPERVISORY_HIERARCHY' ),PPS.name),RLT.routing_list_name) list_name, RCT.override_role_id, decode(RCT.override_role_id,NULL,NULL,ROL.role_name) override_role_name, RCT.override_user_id, decode(RCT.override_user_id,NULL,NULL,USR.user_name) override_user_name, RCT.override_position_id, decode( RCT.override_position_id,NULL,NULL,POS.name) override_position_name, RCT.override_assignment_id, decode(RCT.override_assignment_id,NULL,NULL,pqh_tct_wizard_pkg.return_person_name(RCT.override_assignment_id)) override_assignment_name, RCT.object_version_number, RCT.last_update_date, RCT.creation_date, RCT.created_by, RCT.last_update_login, RCT.last_updated_by FROM pqh_routing_categories RCT,pqh_routing_lists RLT, pqh_roles ROL,fnd_user USR, per_position_structures PPS, hr_all_positions POS WHERE RCT.routing_list_id = RLT.routing_list_id(+) and RCT.position_structure_id = PPS.position_structure_id(+) and RCT.override_role_id = ROL.role_id(+) and RCT.override_user_id = USR.user_id(+) and RCT.override_position_id = POS.position_id(+)

View Text - HTML Formatted

SELECT RCT.ROUTING_CATEGORY_ID
, RCT.TRANSACTION_CATEGORY_ID
, RCT.ENABLE_FLAG
, RCT.DEFAULT_FLAG
, RCT.DELETE_FLAG
, DECODE(RCT.ROUTING_LIST_ID
, NULL
, DECODE( RCT.POSITION_STRUCTURE_ID
, NULL
, 'S'
, 'P')
, 'R') MEMBER_CD
, DECODE(RCT.ROUTING_LIST_ID
, NULL
, DECODE( RCT.POSITION_STRUCTURE_ID
, NULL
, NULL
, RCT.POSITION_STRUCTURE_ID)
, RCT.ROUTING_LIST_ID) LIST_ID
, DECODE(RCT.ROUTING_LIST_ID
, NULL
, DECODE( RCT.POSITION_STRUCTURE_ID
, NULL
, HR_GENERAL.DECODE_LOOKUP( 'PQH_SUPERVISORY_HIERARCHY'
, 'SUPERVISORY_HIERARCHY' )
, PPS.NAME)
, RLT.ROUTING_LIST_NAME) LIST_NAME
, RCT.OVERRIDE_ROLE_ID
, DECODE(RCT.OVERRIDE_ROLE_ID
, NULL
, NULL
, ROL.ROLE_NAME) OVERRIDE_ROLE_NAME
, RCT.OVERRIDE_USER_ID
, DECODE(RCT.OVERRIDE_USER_ID
, NULL
, NULL
, USR.USER_NAME) OVERRIDE_USER_NAME
, RCT.OVERRIDE_POSITION_ID
, DECODE( RCT.OVERRIDE_POSITION_ID
, NULL
, NULL
, POS.NAME) OVERRIDE_POSITION_NAME
, RCT.OVERRIDE_ASSIGNMENT_ID
, DECODE(RCT.OVERRIDE_ASSIGNMENT_ID
, NULL
, NULL
, PQH_TCT_WIZARD_PKG.RETURN_PERSON_NAME(RCT.OVERRIDE_ASSIGNMENT_ID)) OVERRIDE_ASSIGNMENT_NAME
, RCT.OBJECT_VERSION_NUMBER
, RCT.LAST_UPDATE_DATE
, RCT.CREATION_DATE
, RCT.CREATED_BY
, RCT.LAST_UPDATE_LOGIN
, RCT.LAST_UPDATED_BY
FROM PQH_ROUTING_CATEGORIES RCT
, PQH_ROUTING_LISTS RLT
, PQH_ROLES ROL
, FND_USER USR
, PER_POSITION_STRUCTURES PPS
, HR_ALL_POSITIONS POS
WHERE RCT.ROUTING_LIST_ID = RLT.ROUTING_LIST_ID(+)
AND RCT.POSITION_STRUCTURE_ID = PPS.POSITION_STRUCTURE_ID(+)
AND RCT.OVERRIDE_ROLE_ID = ROL.ROLE_ID(+)
AND RCT.OVERRIDE_USER_ID = USR.USER_ID(+)
AND RCT.OVERRIDE_POSITION_ID = POS.POSITION_ID(+)