View: PO_DOCUMENT_VERSIONS_V

Product:	PO - Purchasing
Description:	This view is required to provide version information on documents for contracts.
Implementation/DBA Data:	APPS.PO_DOCUMENT_VERSIONS_V

View Text

SELECT POA.PO_HEADER_ID DOCUMENT_ID
, DECODE(POA.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PO_STANDARD'
, 'BLANKET'
, 'PA_BLANKET'
, 'CONTRACT'
, 'PA_CONTRACT') DOCUMENT_TYPE
, POA.REVISION_NUM DOCUMENT_VERSION
, POA.AUTHORIZATION_STATUS STATUS
, 'Y' ARCHIVED_YN
FROM PO_HEADERS_ARCHIVE_ALL POA UNION SELECT POH.PO_HEADER_ID DOCUMENT_ID
, DECODE(POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PO_STANDARD'
, 'BLANKET'
, 'PA_BLANKET'
, 'CONTRACT'
, 'PA_CONTRACT') DOCUMENT_TYPE
, POH.REVISION_NUM DOCUMENT_VERSION
, POH.AUTHORIZATION_STATUS STATUS
, 'N' ARCHIVED_YN
FROM PO_HEADERS_ALL POH
, PO_HEADERS_ARCHIVE_ALL POHA
WHERE POHA.PO_HEADER_ID(+) = POH.PO_HEADER_ID
AND NVL(POHA.LATEST_EXTERNAL_FLAG
, 'Y') = 'Y'
AND POH.REVISION_NUM > NVL(POHA.REVISION_NUM
, -1)

Columns