View: PO_HEADERS_VIEW

Product:	PO - Purchasing
Description:	Document headers
Implementation/DBA Data:	APPS.PO_HEADERS_VIEW

View Text

SELECT POH.PO_HEADER_ID
, TO_NUMBER('')
, POH.SEGMENT1
, POH.REVISION_NUM
, POH.TYPE_LOOKUP_CODE
, POH.APPROVED_FLAG
, POH.APPROVED_DATE
, POH.ACCEPTANCE_REQUIRED_FLAG
, POH.ACCEPTANCE_DUE_DATE
, TO_NUMBER('')
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POH.AGENT_ID
, POH.START_DATE
, POH.END_DATE
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_LOGIN
, POH.CREATION_DATE
, POH.CREATED_BY
, POH.ORG_ID
FROM PO_HEADERS POH
WHERE NVL(POH.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND POH.APPROVED_DATE IS NOT NULL
AND POH.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'BLANKET'
, 'CONTRACT'
, 'PLANNED') UNION SELECT POR.PO_HEADER_ID
, POR.PO_RELEASE_ID
, POH.SEGMENT1
, POR.REVISION_NUM
, POH.TYPE_LOOKUP_CODE
, POR.APPROVED_FLAG
, POR.APPROVED_DATE
, POR.ACCEPTANCE_REQUIRED_FLAG
, POR.ACCEPTANCE_DUE_DATE
, POR.RELEASE_NUM
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POR.AGENT_ID
, POH.START_DATE
, POH.END_DATE
, POR.LAST_UPDATE_DATE
, POR.LAST_UPDATED_BY
, POR.LAST_UPDATE_LOGIN
, POR.CREATION_DATE
, POR.CREATED_BY
, POR.ORG_ID
FROM PO_RELEASES POR
, PO_HEADERS_ALL POH
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND POR.APPROVED_DATE IS NOT NULL
AND NVL(POH.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND POH.TYPE_LOOKUP_CODE IN ('BLANKET'
, 'PLANNED')

Columns