[Home] [Help]
View: OE_HEADERS_IOP_115_V
View Text
SELECT HEADER_ID
, ORG_ID
, ORDER_TYPE_ID
, ORDER_NUMBER
, DECODE(ORDER_CATEGORY_CODE
, 'ORDER'
, 'R'
, 'RETURN'
, 'RMA'
, 'MIXED'
, NULL
, NULL) ORDER_CATEGORY_CODE
, SOLD_TO_ORG_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM OE_ORDER_HEADERS
Columns
Name |
HEADER_ID |
ORG_ID |
ORDER_TYPE_ID |
ORDER_NUMBER |
ORDER_CATEGORY |
CUSTOMER_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |