VIEW: MRP.MRP_WIP_COMPONENTS#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, WIP_ENTITY_ID WIP_ENTITY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, JOB_REFERENCE_ITEM_ID JOB_REFERENCE_ITEM_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, QUANTITY_REQUIRED QUANTITY_REQUIRED, QUANTITY_ISSUED QUANTITY_ISSUED, ALLOCATED_QUANTITY ALLOCATED_QUANTITY, NET_QUANTITY NET_QUANTITY, OPERATION_START_DATE OPERATION_START_DATE, WIP_ENTITY_TYPE WIP_ENTITY_TYPE, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_TYPE, OPERATION_OFFSET_DAYS OPERATION_OFFSET_DAYS, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP from "MRP"."MRP_WIP_COMPONENTS"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, WIP_ENTITY_ID WIP_ENTITY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, JOB_REFERENCE_ITEM_ID JOB_REFERENCE_ITEM_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
, QUANTITY_REQUIRED QUANTITY_REQUIRED
, QUANTITY_ISSUED QUANTITY_ISSUED
, ALLOCATED_QUANTITY ALLOCATED_QUANTITY
, NET_QUANTITY NET_QUANTITY
, OPERATION_START_DATE OPERATION_START_DATE
, WIP_ENTITY_TYPE WIP_ENTITY_TYPE
, SUPPLY_DEMAND_TYPE SUPPLY_DEMAND_TYPE
, OPERATION_OFFSET_DAYS OPERATION_OFFSET_DAYS
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
FROM "MRP"."MRP_WIP_COMPONENTS"