VIEW: APPS.PO_ACTION_HISTORY_V

Source

View Text - Preformatted

SELECT POAH.ROWID , POAH.CREATED_BY , POAH.ACTION_CODE , POAH.ACTION_DATE , POAH.EMPLOYEE_ID , POAH.APPROVAL_PATH_ID , POAH.NOTE , POAH.OBJECT_REVISION_NUM , POAH.OFFLINE_CODE , POAH.LAST_UPDATE_LOGIN , POAH.REQUEST_ID , POAH.PROGRAM_APPLICATION_ID , POAH.PROGRAM_ID , POAH.PROGRAM_UPDATE_DATE , POAH.PROGRAM_DATE , POAH.OBJECT_ID , POAH.OBJECT_TYPE_CODE , POAH.OBJECT_SUB_TYPE_CODE , POAH.SEQUENCE_NUM , POAH.LAST_UPDATE_DATE , POAH.LAST_UPDATED_BY , POAH.CREATION_DATE , PO_EMPLOYEES_SV.GET_EMP_NAME(POAH.EMPLOYEE_ID) , nvl(POLC1.DISPLAYED_FIELD,POLC2.DISPLAYED_FIELD) FROM PO_ACTION_HISTORY POAH, PO_LOOKUP_CODES POLC1, PO_LOOKUP_CODES POLC2 WHERE POLC1.LOOKUP_CODE (+) = POAH.ACTION_CODE AND POLC1.LOOKUP_TYPE (+)= 'APPROVER ACTIONS' AND POLC2.LOOKUP_CODE (+) = POAH.ACTION_CODE AND POLC2.LOOKUP_TYPE(+) ='CONTROL ACTIONS'

View Text - HTML Formatted

SELECT POAH.ROWID
, POAH.CREATED_BY
, POAH.ACTION_CODE
, POAH.ACTION_DATE
, POAH.EMPLOYEE_ID
, POAH.APPROVAL_PATH_ID
, POAH.NOTE
, POAH.OBJECT_REVISION_NUM
, POAH.OFFLINE_CODE
, POAH.LAST_UPDATE_LOGIN
, POAH.REQUEST_ID
, POAH.PROGRAM_APPLICATION_ID
, POAH.PROGRAM_ID
, POAH.PROGRAM_UPDATE_DATE
, POAH.PROGRAM_DATE
, POAH.OBJECT_ID
, POAH.OBJECT_TYPE_CODE
, POAH.OBJECT_SUB_TYPE_CODE
, POAH.SEQUENCE_NUM
, POAH.LAST_UPDATE_DATE
, POAH.LAST_UPDATED_BY
, POAH.CREATION_DATE
, PO_EMPLOYEES_SV.GET_EMP_NAME(POAH.EMPLOYEE_ID)
, NVL(POLC1.DISPLAYED_FIELD
, POLC2.DISPLAYED_FIELD)
FROM PO_ACTION_HISTORY POAH
, PO_LOOKUP_CODES POLC1
, PO_LOOKUP_CODES POLC2
WHERE POLC1.LOOKUP_CODE (+) = POAH.ACTION_CODE
AND POLC1.LOOKUP_TYPE (+)= 'APPROVER ACTIONS'
AND POLC2.LOOKUP_CODE (+) = POAH.ACTION_CODE
AND POLC2.LOOKUP_TYPE(+) ='CONTROL ACTIONS'