VIEW: ONT.OE_LINES_EXT_IFACE_ALL#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, LINE_ID LINE_ID, ENTITY ENTITY, PROCESS_STATUS PROCESS_STATUS, DATA_SET_ID DATA_SET_ID, ROW_IDENTIFIER ROW_IDENTIFIER, ATTR_GROUP_INT_NAME ATTR_GROUP_INT_NAME, ATTR_INT_NAME ATTR_INT_NAME, ATTR_VALUE_STR ATTR_VALUE_STR, ATTR_VALUE_NUM ATTR_VALUE_NUM, ATTR_VALUE_DATE ATTR_VALUE_DATE, ATTR_DISP_VALUE ATTR_DISP_VALUE, TRANSACTION_TYPE TRANSACTION_TYPE, ATTR_GROUP_ID ATTR_GROUP_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTR_GROUP_TYPE ATTR_GROUP_TYPE, ATTR_UOM_DISP_VALUE ATTR_UOM_DISP_VALUE, ATTR_VALUE_UOM ATTR_VALUE_UOM, DATA_LEVEL_ID DATA_LEVEL_ID, DATA_LEVEL_NAME DATA_LEVEL_NAME, USER_DATA_LEVEL_NAME USER_DATA_LEVEL_NAME, BATCH_ID BATCH_ID, ORDER_SOURCE_ID ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, ORG_ID ORG_ID from "ONT"."OE_LINES_EXT_IFACE_ALL"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, LINE_ID LINE_ID
, ENTITY ENTITY
, PROCESS_STATUS PROCESS_STATUS
, DATA_SET_ID DATA_SET_ID
, ROW_IDENTIFIER ROW_IDENTIFIER
, ATTR_GROUP_INT_NAME ATTR_GROUP_INT_NAME
, ATTR_INT_NAME ATTR_INT_NAME
, ATTR_VALUE_STR ATTR_VALUE_STR
, ATTR_VALUE_NUM ATTR_VALUE_NUM
, ATTR_VALUE_DATE ATTR_VALUE_DATE
, ATTR_DISP_VALUE ATTR_DISP_VALUE
, TRANSACTION_TYPE TRANSACTION_TYPE
, ATTR_GROUP_ID ATTR_GROUP_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTR_GROUP_TYPE ATTR_GROUP_TYPE
, ATTR_UOM_DISP_VALUE ATTR_UOM_DISP_VALUE
, ATTR_VALUE_UOM ATTR_VALUE_UOM
, DATA_LEVEL_ID DATA_LEVEL_ID
, DATA_LEVEL_NAME DATA_LEVEL_NAME
, USER_DATA_LEVEL_NAME USER_DATA_LEVEL_NAME
, BATCH_ID BATCH_ID
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, ORG_ID ORG_ID
FROM "ONT"."OE_LINES_EXT_IFACE_ALL"