VIEW: MTH.MTH_WO_SALES_ORDERS_STG#

Source

View Text - Preformatted

select WORKORDER_FK WORKORDER_FK, SALESORDER_NUMBER SALESORDER_NUMBER, SALESORDER_LNUMBER SALESORDER_LNUMBER, CUSTOMER CUSTOMER, REQUESTED_DATE REQUESTED_DATE, PROMISED_DATE PROMISED_DATE, SCHEDULED_SHIP_DATE SCHEDULED_SHIP_DATE, SYSTEM_FK SYSTEM_FK, QUANTITY_G QUANTITY_G, PRIMARY_UOM PRIMARY_UOM, PRODUCT_FK PRODUCT_FK, USER_DIM1_FK USER_DIM1_FK, USER_DIM2_FK USER_DIM2_FK, USER_DIM3_FK USER_DIM3_FK, USER_DIM4_FK USER_DIM4_FK, USER_DIM5_FK USER_DIM5_FK, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, PROCESSING_FLAG PROCESSING_FLAG, RESERVATION_PK RESERVATION_PK from "MTH"."MTH_WO_SALES_ORDERS_STG"

View Text - HTML Formatted

SELECT WORKORDER_FK WORKORDER_FK
, SALESORDER_NUMBER SALESORDER_NUMBER
, SALESORDER_LNUMBER SALESORDER_LNUMBER
, CUSTOMER CUSTOMER
, REQUESTED_DATE REQUESTED_DATE
, PROMISED_DATE PROMISED_DATE
, SCHEDULED_SHIP_DATE SCHEDULED_SHIP_DATE
, SYSTEM_FK SYSTEM_FK
, QUANTITY_G QUANTITY_G
, PRIMARY_UOM PRIMARY_UOM
, PRODUCT_FK PRODUCT_FK
, USER_DIM1_FK USER_DIM1_FK
, USER_DIM2_FK USER_DIM2_FK
, USER_DIM3_FK USER_DIM3_FK
, USER_DIM4_FK USER_DIM4_FK
, USER_DIM5_FK USER_DIM5_FK
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, PROCESSING_FLAG PROCESSING_FLAG
, RESERVATION_PK RESERVATION_PK
FROM "MTH"."MTH_WO_SALES_ORDERS_STG"