View: POR_APPROVAL_STATUS_LINES_V

Product:	ICX - Oracle iProcurement
Description:	Approval Status Lines View
Implementation/DBA Data:	APPS.POR_APPROVAL_STATUS_LINES_V

View Text

SELECT PAH.OBJECT_ID
, POR_VIEW_REQS_PKG.GET_APPROVER_NAME(PAH.EMPLOYEE_ID)
, PAH.SEQUENCE_NUM
, NVL(PAH.ACTION_CODE
, 'PENDING')
, PLC_STATUS.DISPLAYED_FIELD
, TO_CHAR(PAH.ACTION_DATE
, FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK'))
, PAH.NOTE
, POR_VIEW_REQS_PKG.GET_BUSINESS_GROUP_NAME(PAH.EMPLOYEE_ID)
FROM PO_ACTION_HISTORY PAH
, PO_LOOKUP_CODES PLC_STATUS
WHERE PLC_STATUS.LOOKUP_CODE = NVL(PAH.ACTION_CODE
, 'PENDING')
AND PLC_STATUS.LOOKUP_TYPE IN ( 'APPROVER ACTIONS'
, 'CONTROL ACTIONS')
AND PAH.OBJECT_TYPE_CODE = 'REQUISITION'
AND PAH.OBJECT_SUB_TYPE_CODE = 'PURCHASE' UNION ALL SELECT APLH.DOCUMENT_ID
, POR_VIEW_REQS_PKG.GET_APPROVER_NAME(APLL.APPROVER_ID)
, APLL.SEQUENCE_NUM
, 'NULL'
, NULL
, TO_CHAR(APLL.RESPONSE_DATE
, FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK'))
, APLL.COMMENTS
, POR_VIEW_REQS_PKG.GET_BUSINESS_GROUP_NAME(APLL.APPROVER_ID)
FROM PO_APPROVAL_LIST_HEADERS APLH
, PO_APPROVAL_LIST_LINES APLL
WHERE APLL.APPROVAL_LIST_HEADER_ID = APLH.APPROVAL_LIST_HEADER_ID
AND APLL.SEQUENCE_NUM > APLH.CURRENT_SEQUENCE_NUM
AND APLH.LATEST_REVISION = 'Y'
AND APLH.DOCUMENT_TYPE = 'REQUISITION'
AND APLH.DOCUMENT_SUBTYPE = 'PURCHASE'

Columns