[Home] [Help]
View: MTL_SALES_ORDERS_KFV
View Text
SELECT ROWID
, SALES_ORDER_ID
, SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3
, RPAD(NVL(SEGMENT1
, ' ')
, 40) || '.' || RPAD(NVL(SEGMENT2
, ' ')
, 40) || '.' || RPAD(NVL(SEGMENT3
, ' ')
, 40)
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SOURCE_CODE
, ORDER_TYPE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM MTL_SALES_ORDERS
Columns
Name |
ROW_ID |
SALES_ORDER_ID |
CONCATENATED_SEGMENTS |
PADDED_CONCATENATED_SEGMENTS |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
SUMMARY_FLAG |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
SOURCE_CODE |
ORDER_TYPE |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |