[Home] [Help]
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
Name |
DOCUMENT_ID |
DOCUMENT_TYPE |
DOCUMENT_VERSION |
STATUS |
ARCHIVED_YN |