VIEW: MTH.MTH_MTL_CONSUMED_TXN_LOT_STG#

Source

View Text - Preformatted

select WO_MAT_TXN_FK WO_MAT_TXN_FK, PRODUCT_LOT PRODUCT_LOT, PRODUCT_SUBLOT PRODUCT_SUBLOT, PRODUCT_SERIAL_NO PRODUCT_SERIAL_NO, TRANSACTION_QTY TRANSACTION_QTY, TRANSACTION_QTY_G TRANSACTION_QTY_G, TRANSACTION_QTY_SG TRANSACTION_QTY_SG, TRANSACTION_UOM TRANSACTION_UOM, PRIMARY_UOM PRIMARY_UOM, SECONDARY_UOM SECONDARY_UOM, MATERIAL_LOT MATERIAL_LOT, MATERIAL_SUBLOT MATERIAL_SUBLOT, MATERIAL_SERIAL_NO MATERIAL_SERIAL_NO, SYSTEM_FK SYSTEM_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, GRADE GRADE, PROCESSING_FLAG PROCESSING_FLAG from "MTH"."MTH_MTL_CONSUMED_TXN_LOT_STG"

View Text - HTML Formatted

SELECT WO_MAT_TXN_FK WO_MAT_TXN_FK
, PRODUCT_LOT PRODUCT_LOT
, PRODUCT_SUBLOT PRODUCT_SUBLOT
, PRODUCT_SERIAL_NO PRODUCT_SERIAL_NO
, TRANSACTION_QTY TRANSACTION_QTY
, TRANSACTION_QTY_G TRANSACTION_QTY_G
, TRANSACTION_QTY_SG TRANSACTION_QTY_SG
, TRANSACTION_UOM TRANSACTION_UOM
, PRIMARY_UOM PRIMARY_UOM
, SECONDARY_UOM SECONDARY_UOM
, MATERIAL_LOT MATERIAL_LOT
, MATERIAL_SUBLOT MATERIAL_SUBLOT
, MATERIAL_SERIAL_NO MATERIAL_SERIAL_NO
, SYSTEM_FK SYSTEM_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
, GRADE GRADE
, PROCESSING_FLAG PROCESSING_FLAG
FROM "MTH"."MTH_MTL_CONSUMED_TXN_LOT_STG"