View: PQH_ROUTING_HISTORY_V

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

View Text

SELECT ROUTING_HISTORY_ID ROUTING_HISTORY_ID
, APPROVAL_CD APPROVAL_CD
, COMMENTS COMMENTS
, PQH_WF.GET_PERSON_NAME(RHT.FORWARDED_BY_USER_ID
, RHT.FORWARDED_BY_ASSIGNMENT_ID) PERSON_NAME_BY
, RLS_BY.ROLE_NAME ROLE_NAME_BY
, HR_GENERAL.DECODE_POSITION(FORWARDED_BY_POSITION_ID) POSITION_NAME_BY
, USR_BY.USER_NAME USER_NAME_BY
, PQH_WF.GET_PERSON_NAME (RHT.FORWARDED_TO_USER_ID
, RHT.FORWARDED_TO_ASSIGNMENT_ID) PERSON_NAME_TO
, RLS_TO.ROLE_NAME ROLE_NAME_TO
, HR_GENERAL.DECODE_POSITION(FORWARDED_TO_POSITION_ID) POSITION_NAME_TO
, USR_TO.USER_NAME USER_NAME_TO
, NOTIFICATION_DATE NOTIFICATION_DATE
, POS_STRUCTURE_VERSION_ID POS_STRUCTURE_VERSION_ID
, ROUTING_CATEGORY_ID ROUTING_CATEGORY_ID
, TRANSACTION_CATEGORY_ID TRANSACTION_CATEGORY_ID
, TRANSACTION_ID TRANSACTION_ID
, USER_ACTION_CD USER_ACTION_CD
, RHT.FORWARDED_BY_USER_ID FORWARDED_BY_USER_ID
, RHT.FORWARDED_BY_ASSIGNMENT_ID FORWARDED_BY_ASSIGNMENT_ID
, RHT.FORWARDED_BY_POSITION_ID FORWARDED_BY_POSITION_ID
, RHT.FORWARDED_BY_MEMBER_ID FORWARDED_BY_MEMBER_ID
, RHT.FORWARDED_TO_USER_ID FORWARDED_TO_USER_ID
, RHT.FORWARDED_TO_ASSIGNMENT_ID FORWARDED_TO_ASSIGNMENT_ID
, RHT.FORWARDED_TO_POSITION_ID FORWARDED_TO_POSITION_ID
, RHT.FORWARDED_TO_MEMBER_ID FORWARDED_TO_MEMBER_ID
FROM PQH_ROUTING_HISTORY RHT
, PQH_ROUTING_LIST_MEMBERS RLM_TO
, PQH_ROUTING_LIST_MEMBERS RLM_BY
, PQH_ROLES RLS_TO
, PQH_ROLES RLS_BY
, FND_USER USR_TO
, FND_USER USR_BY
WHERE RHT.FORWARDED_TO_MEMBER_ID = RLM_TO.ROUTING_LIST_MEMBER_ID(+)
AND RHT.FORWARDED_BY_MEMBER_ID = RLM_BY.ROUTING_LIST_MEMBER_ID(+)
AND RHT.FORWARDED_TO_ROLE_ID = RLS_TO.ROLE_ID (+)
AND RHT.FORWARDED_BY_ROLE_ID = RLS_BY.ROLE_ID (+)
AND RHT.FORWARDED_TO_USER_ID = USR_TO.USER_ID (+)
AND RHT.FORWARDED_BY_USER_ID = USR_BY.USER_ID (+)

Columns