VIEW: MSD.MSD_ST_SHIPMENT_DATA#

Source

View Text - Preformatted

select INSTANCE INSTANCE, INV_ORG INV_ORG, ITEM ITEM, CUSTOMER CUSTOMER, SALES_CHANNEL SALES_CHANNEL, SALES_REP SALES_REP, SHIP_TO_LOC SHIP_TO_LOC, USER_DEFINED1 USER_DEFINED1, USER_DEFINED2 USER_DEFINED2, BOOKED_DATE BOOKED_DATE, REQUESTED_DATE REQUESTED_DATE, PROMISED_DATE PROMISED_DATE, SHIPPED_DATE SHIPPED_DATE, AMOUNT AMOUNT, QTY_SHIPPED QTY_SHIPPED, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SR_INV_ORG_PK SR_INV_ORG_PK, SR_ITEM_PK SR_ITEM_PK, SR_CUSTOMER_PK SR_CUSTOMER_PK, SR_SALES_CHANNEL_PK SR_SALES_CHANNEL_PK, SR_SALES_REP_PK SR_SALES_REP_PK, SR_SHIP_TO_LOC_PK SR_SHIP_TO_LOC_PK, SR_USER_DEFINED1_PK SR_USER_DEFINED1_PK, SR_USER_DEFINED2_PK SR_USER_DEFINED2_PK, SR_ORIGINAL_ITEM_PK SR_ORIGINAL_ITEM_PK, ORIGINAL_ITEM ORIGINAL_ITEM, SR_INSTANCE_CODE SR_INSTANCE_CODE, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, BATCH_ID BATCH_ID, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, MESSAGE_ID MESSAGE_ID, USER_DEFINED_LEVEL1 USER_DEFINED_LEVEL1, USER_DEFINED_LEVEL2 USER_DEFINED_LEVEL2, SR_PARENT_ITEM_PK SR_PARENT_ITEM_PK, PARENT_ITEM PARENT_ITEM, SCHEDULED_SHIP_DATE SCHEDULED_SHIP_DATE, SCHEDULED_ARRIVAL_DATE SCHEDULED_ARRIVAL_DATE, SR_DEMAND_CLASS_PK SR_DEMAND_CLASS_PK, DEMAND_CLASS_LVL_VAL DEMAND_CLASS_LVL_VAL, ORDER_SOURCE_ID ORDER_SOURCE_ID from "MSD"."MSD_ST_SHIPMENT_DATA"

View Text - HTML Formatted

SELECT INSTANCE INSTANCE
, INV_ORG INV_ORG
, ITEM ITEM
, CUSTOMER CUSTOMER
, SALES_CHANNEL SALES_CHANNEL
, SALES_REP SALES_REP
, SHIP_TO_LOC SHIP_TO_LOC
, USER_DEFINED1 USER_DEFINED1
, USER_DEFINED2 USER_DEFINED2
, BOOKED_DATE BOOKED_DATE
, REQUESTED_DATE REQUESTED_DATE
, PROMISED_DATE PROMISED_DATE
, SHIPPED_DATE SHIPPED_DATE
, AMOUNT AMOUNT
, QTY_SHIPPED QTY_SHIPPED
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SR_INV_ORG_PK SR_INV_ORG_PK
, SR_ITEM_PK SR_ITEM_PK
, SR_CUSTOMER_PK SR_CUSTOMER_PK
, SR_SALES_CHANNEL_PK SR_SALES_CHANNEL_PK
, SR_SALES_REP_PK SR_SALES_REP_PK
, SR_SHIP_TO_LOC_PK SR_SHIP_TO_LOC_PK
, SR_USER_DEFINED1_PK SR_USER_DEFINED1_PK
, SR_USER_DEFINED2_PK SR_USER_DEFINED2_PK
, SR_ORIGINAL_ITEM_PK SR_ORIGINAL_ITEM_PK
, ORIGINAL_ITEM ORIGINAL_ITEM
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, BATCH_ID BATCH_ID
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, MESSAGE_ID MESSAGE_ID
, USER_DEFINED_LEVEL1 USER_DEFINED_LEVEL1
, USER_DEFINED_LEVEL2 USER_DEFINED_LEVEL2
, SR_PARENT_ITEM_PK SR_PARENT_ITEM_PK
, PARENT_ITEM PARENT_ITEM
, SCHEDULED_SHIP_DATE SCHEDULED_SHIP_DATE
, SCHEDULED_ARRIVAL_DATE SCHEDULED_ARRIVAL_DATE
, SR_DEMAND_CLASS_PK SR_DEMAND_CLASS_PK
, DEMAND_CLASS_LVL_VAL DEMAND_CLASS_LVL_VAL
, ORDER_SOURCE_ID ORDER_SOURCE_ID
FROM "MSD"."MSD_ST_SHIPMENT_DATA"