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