VIEW: APPS.PO_DOCUMENT_VERSIONS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)