Product: | GHR - US Federal Human Resources |
---|---|
Description: | Personnel Action (PA) Routing History deatils view |
Implementation/DBA Data: | APPS.GHR_PA_ROUTING_HISTORY_V |
SELECT PRH.ROWID ROW_ID
, PRH.PA_ROUTING_HISTORY_ID
, PRH.PA_REQUEST_ID
, PRH.ATTACHMENT_MODIFIED_FLAG
, PRH.INITIATOR_FLAG
, PRH.APPROVER_FLAG
, PRH.REVIEWER_FLAG
, PRH.REQUESTER_FLAG
, PRH.AUTHORIZER_FLAG
, PRH.PERSONNELIST_FLAG
, PRH.APPROVED_FLAG
, PRH.APPROVAL_STATUS
, PRH.USER_NAME
, PRH.USER_NAME_EMPLOYEE_ID
, PRH.USER_NAME_EMP_FIRST_NAME
, PRH.USER_NAME_EMP_LAST_NAME
, PRH.USER_NAME_EMP_MIDDLE_NAMES
, PRH.USER_NAME_EMP_LAST_NAME||DECODE(PRH.USER_NAME_EMP_LAST_NAME
, NULL
, NULL
, '
, ')|| PRH.USER_NAME_EMP_FIRST_NAME||' '|| PRH.USER_NAME_EMP_MIDDLE_NAMES USER_NAME_EMP_FULL_NAME
, PRH.NOTEPAD
, PRH.ACTION_TAKEN
, PRH.GROUPBOX_ID
, GBX.NAME GROUPBOX_NAME
, PRH.ROUTING_LIST_ID
, RLS.NAME ROUTING_LIST_NAME
, PRH.ROUTING_SEQ_NUMBER
, PRH.NOA_FAMILY_CODE
, FAM.NAME FAMILY_NAME
, PRH.NATURE_OF_ACTION_ID
, NOA.CODE NOA_CODE
, NOA.DESCRIPTION NOA_DESCRIPTION
, PRH.SECOND_NATURE_OF_ACTION_ID
, NOA2.CODE SECOND_NOA_CODE
, NOA2.DESCRIPTION SECOND_NOA_DESCRIPTION
, PRH.OBJECT_VERSION_NUMBER
, PRH.DATE_NOTIFICATION_SENT
, PRH.LAST_UPDATE_DATE
, PRH.LAST_UPDATED_BY
, PRH.LAST_UPDATE_LOGIN
, PRH.CREATED_BY
, PRH.CREATION_DATE
FROM GHR_FAMILIES FAM
, GHR_NATURE_OF_ACTIONS NOA2
, GHR_NATURE_OF_ACTIONS NOA
, GHR_ROUTING_LISTS RLS
, GHR_GROUPBOXES GBX
, GHR_PA_ROUTING_HISTORY PRH
WHERE GBX.GROUPBOX_ID(+) = PRH.GROUPBOX_ID
AND RLS.ROUTING_LIST_ID(+) = PRH.ROUTING_LIST_ID
AND NOA.NATURE_OF_ACTION_ID(+) = PRH.NATURE_OF_ACTION_ID
AND NOA2.NATURE_OF_ACTION_ID(+) = PRH.SECOND_NATURE_OF_ACTION_ID
AND FAM.NOA_FAMILY_CODE(+) = PRH.NOA_FAMILY_CODE