VIEW: MTH.MTH_PROD_MTL_PRODUCED_I_STG#

Source

View Text - Preformatted

select WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_CODE ORGANIZATION_CODE, ORGANIZATION_ID ORGANIZATION_ID, DB_GLOBAL_NAME DB_GLOBAL_NAME, PRIMARY_ITEM_ID PRIMARY_ITEM_ID, START_QUANTITY_G START_QUANTITY_G, START_QUANTITY_SG START_QUANTITY_SG, EXPECTED_YIELD EXPECTED_YIELD, ACTUAL_COMP_QTY_G ACTUAL_COMP_QTY_G, ACTUAL_COMP_QTY_SG ACTUAL_COMP_QTY_SG, ACTUAL_REJECTED_QTY_G ACTUAL_REJECTED_QTY_G, ACTUAL_REJECTED_QTY_SG ACTUAL_REJECTED_QTY_SG, ACTUAL_REWORKED_QTY_G ACTUAL_REWORKED_QTY_G, ACTUAL_REWORKED_QTY_SG ACTUAL_REWORKED_QTY_SG, ACTUAL_SCRAP_QTY_G ACTUAL_SCRAP_QTY_G, ACTUAL_SCRAP_QTY_SG ACTUAL_SCRAP_QTY_SG, ITEM_TYPE_CODE ITEM_TYPE_CODE, HUB_ORGANIZATION_CODE HUB_ORGANIZATION_CODE, WIP_PLAN_QTY_SG WIP_PLAN_QTY_SG, WIP_PLAN_QTY_G WIP_PLAN_QTY_G, CONTRIBUTE_YIELD_FLAG CONTRIBUTE_YIELD_FLAG from "MTH"."MTH_PROD_MTL_PRODUCED_I_STG"

View Text - HTML Formatted

SELECT WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, DB_GLOBAL_NAME DB_GLOBAL_NAME
, PRIMARY_ITEM_ID PRIMARY_ITEM_ID
, START_QUANTITY_G START_QUANTITY_G
, START_QUANTITY_SG START_QUANTITY_SG
, EXPECTED_YIELD EXPECTED_YIELD
, ACTUAL_COMP_QTY_G ACTUAL_COMP_QTY_G
, ACTUAL_COMP_QTY_SG ACTUAL_COMP_QTY_SG
, ACTUAL_REJECTED_QTY_G ACTUAL_REJECTED_QTY_G
, ACTUAL_REJECTED_QTY_SG ACTUAL_REJECTED_QTY_SG
, ACTUAL_REWORKED_QTY_G ACTUAL_REWORKED_QTY_G
, ACTUAL_REWORKED_QTY_SG ACTUAL_REWORKED_QTY_SG
, ACTUAL_SCRAP_QTY_G ACTUAL_SCRAP_QTY_G
, ACTUAL_SCRAP_QTY_SG ACTUAL_SCRAP_QTY_SG
, ITEM_TYPE_CODE ITEM_TYPE_CODE
, HUB_ORGANIZATION_CODE HUB_ORGANIZATION_CODE
, WIP_PLAN_QTY_SG WIP_PLAN_QTY_SG
, WIP_PLAN_QTY_G WIP_PLAN_QTY_G
, CONTRIBUTE_YIELD_FLAG CONTRIBUTE_YIELD_FLAG
FROM "MTH"."MTH_PROD_MTL_PRODUCED_I_STG"