VIEW: MRP.MRP_WORKBENCH_QUERY#

Source

View Text - Preformatted

select QUERY_ID QUERY_ID, TRANSACTION_ID TRANSACTION_ID, LINE_ID LINE_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, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, DESIGNATOR DESIGNATOR, CURRENT_SCHEDULE_DATE CURRENT_SCHEDULE_DATE, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE, CURRENT_ORDER_DATE CURRENT_ORDER_DATE, NEW_ORDER_DATE NEW_ORDER_DATE, CURRENT_DOCK_DATE CURRENT_DOCK_DATE, NEW_DOCK_DATE NEW_DOCK_DATE, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY, CURRENT_ORDER_QUANTITY CURRENT_ORDER_QUANTITY, ORDER_NUMBER ORDER_NUMBER, ORDER_TYPE ORDER_TYPE, DAILY_RATE DAILY_RATE, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE, STATUS_CODE STATUS_CODE, PROCESSING_DAYS PROCESSING_DAYS, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE, LOAD_TYPE LOAD_TYPE, WIP_CLASS_CODE WIP_CLASS_CODE, DISPOSITION DISPOSITION, DISPOSITION_STATUS_TYPE DISPOSITION_STATUS_TYPE, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS, OUTSTANDING_QUANTITY OUTSTANDING_QUANTITY, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY, IMPLEMENT_DATE IMPLEMENT_DATE, FIRM_QUANTITY FIRM_QUANTITY, FIRM_DATE FIRM_DATE, UOM_CODE UOM_CODE, LOCATION_ID LOCATION_ID, EMPLOYEE_ID EMPLOYEE_ID, PURCH_LINE_NUM PURCH_LINE_NUM, DEMAND_CLASS DEMAND_CLASS, RESCHEDULED_FLAG RESCHEDULED_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY from "MRP"."MRP_WORKBENCH_QUERY"

View Text - HTML Formatted

SELECT QUERY_ID QUERY_ID
, TRANSACTION_ID TRANSACTION_ID
, LINE_ID LINE_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
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DESIGNATOR DESIGNATOR
, CURRENT_SCHEDULE_DATE CURRENT_SCHEDULE_DATE
, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE
, CURRENT_ORDER_DATE CURRENT_ORDER_DATE
, NEW_ORDER_DATE NEW_ORDER_DATE
, CURRENT_DOCK_DATE CURRENT_DOCK_DATE
, NEW_DOCK_DATE NEW_DOCK_DATE
, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY
, CURRENT_ORDER_QUANTITY CURRENT_ORDER_QUANTITY
, ORDER_NUMBER ORDER_NUMBER
, ORDER_TYPE ORDER_TYPE
, DAILY_RATE DAILY_RATE
, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE
, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE
, STATUS_CODE STATUS_CODE
, PROCESSING_DAYS PROCESSING_DAYS
, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE
, LOAD_TYPE LOAD_TYPE
, WIP_CLASS_CODE WIP_CLASS_CODE
, DISPOSITION DISPOSITION
, DISPOSITION_STATUS_TYPE DISPOSITION_STATUS_TYPE
, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS
, OUTSTANDING_QUANTITY OUTSTANDING_QUANTITY
, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY
, IMPLEMENT_DATE IMPLEMENT_DATE
, FIRM_QUANTITY FIRM_QUANTITY
, FIRM_DATE FIRM_DATE
, UOM_CODE UOM_CODE
, LOCATION_ID LOCATION_ID
, EMPLOYEE_ID EMPLOYEE_ID
, PURCH_LINE_NUM PURCH_LINE_NUM
, DEMAND_CLASS DEMAND_CLASS
, RESCHEDULED_FLAG RESCHEDULED_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
FROM "MRP"."MRP_WORKBENCH_QUERY"