VIEW: MRP.MRP_AD_WIP_COMP_SUPPLIES#

Source

View Text - Preformatted

select JOB_TYPE JOB_TYPE, WJS_NET_QTY_FLAG WJS_NET_QTY_FLAG, WJS_MPS_NET_QTY_FLAG WJS_MPS_NET_QTY_FLAG, MRP_NET_FLAG MRP_NET_FLAG, ST_MPS_NET_FLAG ST_MPS_NET_FLAG, NST_NMPS_FLAG NST_NMPS_FLAG, NST_MPS_FLAG NST_MPS_FLAG, ST_NMPS_FLAG ST_NMPS_FLAG, ST_MPS_FLAG ST_MPS_FLAG, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, WIP_ENTITY_ID WIP_ENTITY_ID, 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, RN RN, ORGANIZATION_ID ORGANIZATION_ID, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, ENTITY_TYPE ENTITY_TYPE from "MRP"."MRP_AD_WIP_COMP_SUPPLIES"

View Text - HTML Formatted

SELECT JOB_TYPE JOB_TYPE
, WJS_NET_QTY_FLAG WJS_NET_QTY_FLAG
, WJS_MPS_NET_QTY_FLAG WJS_MPS_NET_QTY_FLAG
, MRP_NET_FLAG MRP_NET_FLAG
, ST_MPS_NET_FLAG ST_MPS_NET_FLAG
, NST_NMPS_FLAG NST_NMPS_FLAG
, NST_MPS_FLAG NST_MPS_FLAG
, ST_NMPS_FLAG ST_NMPS_FLAG
, ST_MPS_FLAG ST_MPS_FLAG
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, WIP_ENTITY_ID WIP_ENTITY_ID
, 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
, RN RN
, ORGANIZATION_ID ORGANIZATION_ID
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, ENTITY_TYPE ENTITY_TYPE
FROM "MRP"."MRP_AD_WIP_COMP_SUPPLIES"