View: PQH_ROUTING_CATEGORIES_V

Product:	PQH - Public Sector HR
Description:
Implementation/DBA Data:	APPS.PQH_ROUTING_CATEGORIES_V

View Text

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_UTILITY.DECODE_ASSIGNMENT_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(+)

Columns