[Home] [Help]
View: OE_ORDER_VERSIONS_V
View Text
SELECT HEADER_ID
, NVL(SALES_DOCUMENT_TYPE_CODE
, 'O')
, VERSION_NUMBER
, DECODE(NVL(TO_CHAR(CUSTOMER_SIGNATURE_DATE)
, 'N')
, 'N'
, 'N'
, 'Y') SIGNED_YN
, 'N' ARCHIVED_YN
FROM OE_ORDER_HEADERS_ALL UNION SELECT HEADER_ID
, NVL(SALES_DOCUMENT_TYPE_CODE
, 'O')
, VERSION_NUMBER
, DECODE(NVL(TO_CHAR(CUSTOMER_SIGNATURE_DATE)
, 'N')
, 'N'
, 'N'
, 'Y') SIGNED_YN
, 'Y' ARCHIVED_YN
FROM OE_ORDER_HEADER_HISTORY
WHERE VERSION_FLAG = 'Y' ORDER BY VERSION_NUMBER DESC
Columns
Name |
DOCUMENT_ID |
DOCUMENT_TYPE |
DOCUMENT_VERSION |
SIGNED_YN |
ARCHIVED_YN |