VIEW: BOM.CST_WIP_LAYERS#

Source

View Text - Preformatted

select WIP_LAYER_ID WIP_LAYER_ID, WIP_ENTITY_ID WIP_ENTITY_ID, RELIEVED_MATL_FINAL_COMP_QTY RELIEVED_MATL_FINAL_COMP_QTY, TEMP_RELIEVED_QTY TEMP_RELIEVED_QTY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_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, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, INV_LAYER_ID INV_LAYER_ID, INV_LAYER_DATE INV_LAYER_DATE, CREATE_TXN_ID CREATE_TXN_ID, APPLIED_MATL_QTY APPLIED_MATL_QTY, RELIEVED_MATL_COMP_QTY RELIEVED_MATL_COMP_QTY, RELIEVED_MATL_SCRAP_QTY RELIEVED_MATL_SCRAP_QTY from "BOM"."CST_WIP_LAYERS"

View Text - HTML Formatted

SELECT WIP_LAYER_ID WIP_LAYER_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, RELIEVED_MATL_FINAL_COMP_QTY RELIEVED_MATL_FINAL_COMP_QTY
, TEMP_RELIEVED_QTY TEMP_RELIEVED_QTY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_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
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, INV_LAYER_ID INV_LAYER_ID
, INV_LAYER_DATE INV_LAYER_DATE
, CREATE_TXN_ID CREATE_TXN_ID
, APPLIED_MATL_QTY APPLIED_MATL_QTY
, RELIEVED_MATL_COMP_QTY RELIEVED_MATL_COMP_QTY
, RELIEVED_MATL_SCRAP_QTY RELIEVED_MATL_SCRAP_QTY
FROM "BOM"."CST_WIP_LAYERS"