VIEW: APPS.GHR_PA_ROUTING_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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