VIEW: MRP.MRP_RECOMMENDATIONS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_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, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE, OLD_SCHEDULE_DATE OLD_SCHEDULE_DATE, NEW_WIP_START_DATE NEW_WIP_START_DATE, OLD_WIP_START_DATE OLD_WIP_START_DATE, DISPOSITION_ID DISPOSITION_ID, DISPOSITION_STATUS_TYPE DISPOSITION_STATUS_TYPE, ORDER_TYPE ORDER_TYPE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY, OLD_ORDER_QUANTITY OLD_ORDER_QUANTITY, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE, OLD_ORDER_PLACEMENT_DATE OLD_ORDER_PLACEMENT_DATE, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE, RESCHEDULED_FLAG RESCHEDULED_FLAG, SCHEDULE_COMPRESSION_DAYS SCHEDULE_COMPRESSION_DAYS, NEW_PROCESSING_DAYS NEW_PROCESSING_DAYS, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY, PURCH_LINE_NUM PURCH_LINE_NUM, REVISION REVISION, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE, LAST_UNIT_START_DATE LAST_UNIT_START_DATE, DAILY_RATE DAILY_RATE, OLD_DOCK_DATE OLD_DOCK_DATE, NEW_DOCK_DATE NEW_DOCK_DATE, SUPPLY_AVAIL_DATE SUPPLY_AVAIL_DATE, RESCHEDULE_DAYS RESCHEDULE_DAYS, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS, FIRM_QUANTITY FIRM_QUANTITY, FIRM_DATE FIRM_DATE, NETTING_DATE NETTING_DATE, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE, UPDATED UPDATED, STATUS STATUS, APPLIED APPLIED, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS, IMPLEMENT_DATE IMPLEMENT_DATE, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY, IMPLEMENT_FIRM IMPLEMENT_FIRM, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE, IMPLEMENT_JOB_NAME IMPLEMENT_JOB_NAME, IMPLEMENT_DOCK_DATE IMPLEMENT_DOCK_DATE, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE, IMPLEMENT_EMPLOYEE_ID IMPLEMENT_EMPLOYEE_ID, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID, IMPLEMENT_VENDOR_ID IMPLEMENT_VENDOR_ID, IMPLEMENT_VENDOR_SITE_ID IMPLEMENT_VENDOR_SITE_ID, RELEASE_STATUS RELEASE_STATUS, LOAD_TYPE LOAD_TYPE, IMPLEMENT_AS IMPLEMENT_AS, DEMAND_CLASS DEMAND_CLASS, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, LINE_ID LINE_ID, SOURCE SOURCE, BY_PRODUCT_USING_ASSY_ID BY_PRODUCT_USING_ASSY_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_VENDOR_SITE_ID SOURCE_VENDOR_SITE_ID, SOURCE_VENDOR_ID SOURCE_VENDOR_ID, SOURCE_SUPPLY_SCHEDULE_NAME SOURCE_SUPPLY_SCHEDULE_NAME, NEW_SHIP_DATE NEW_SHIP_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, IMPLEMENT_PROJECT_ID IMPLEMENT_PROJECT_ID, IMPLEMENT_TASK_ID IMPLEMENT_TASK_ID, IMPLEMENT_SCHEDULE_GROUP_ID IMPLEMENT_SCHEDULE_GROUP_ID, IMPLEMENT_BUILD_SEQUENCE IMPLEMENT_BUILD_SEQUENCE, IMPLEMENT_ALTERNATE_BOM IMPLEMENT_ALTERNATE_BOM, IMPLEMENT_ALTERNATE_ROUTING IMPLEMENT_ALTERNATE_ROUTING, IMPLEMENT_LINE_ID IMPLEMENT_LINE_ID, SOURCE_ITEM_ID SOURCE_ITEM_ID, RELEASE_ERRORS RELEASE_ERRORS, NUMBER1 NUMBER1, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, IMPLEMENT_END_ITEM_UNIT_NUMBER IMPLEMENT_END_ITEM_UNIT_NUMBER from "MRP"."MRP_RECOMMENDATIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_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
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, NEW_SCHEDULE_DATE NEW_SCHEDULE_DATE
, OLD_SCHEDULE_DATE OLD_SCHEDULE_DATE
, NEW_WIP_START_DATE NEW_WIP_START_DATE
, OLD_WIP_START_DATE OLD_WIP_START_DATE
, DISPOSITION_ID DISPOSITION_ID
, DISPOSITION_STATUS_TYPE DISPOSITION_STATUS_TYPE
, ORDER_TYPE ORDER_TYPE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, NEW_ORDER_QUANTITY NEW_ORDER_QUANTITY
, OLD_ORDER_QUANTITY OLD_ORDER_QUANTITY
, NEW_ORDER_PLACEMENT_DATE NEW_ORDER_PLACEMENT_DATE
, OLD_ORDER_PLACEMENT_DATE OLD_ORDER_PLACEMENT_DATE
, FIRM_PLANNED_TYPE FIRM_PLANNED_TYPE
, RESCHEDULED_FLAG RESCHEDULED_FLAG
, SCHEDULE_COMPRESSION_DAYS SCHEDULE_COMPRESSION_DAYS
, NEW_PROCESSING_DAYS NEW_PROCESSING_DAYS
, IMPLEMENTED_QUANTITY IMPLEMENTED_QUANTITY
, PURCH_LINE_NUM PURCH_LINE_NUM
, REVISION REVISION
, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE
, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE
, LAST_UNIT_START_DATE LAST_UNIT_START_DATE
, DAILY_RATE DAILY_RATE
, OLD_DOCK_DATE OLD_DOCK_DATE
, NEW_DOCK_DATE NEW_DOCK_DATE
, SUPPLY_AVAIL_DATE SUPPLY_AVAIL_DATE
, RESCHEDULE_DAYS RESCHEDULE_DAYS
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUANTITY_IN_PROCESS QUANTITY_IN_PROCESS
, FIRM_QUANTITY FIRM_QUANTITY
, FIRM_DATE FIRM_DATE
, NETTING_DATE NETTING_DATE
, PLANNING_MAKE_BUY_CODE PLANNING_MAKE_BUY_CODE
, UPDATED UPDATED
, STATUS STATUS
, APPLIED APPLIED
, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS
, IMPLEMENT_DATE IMPLEMENT_DATE
, IMPLEMENT_QUANTITY IMPLEMENT_QUANTITY
, IMPLEMENT_FIRM IMPLEMENT_FIRM
, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE
, IMPLEMENT_JOB_NAME IMPLEMENT_JOB_NAME
, IMPLEMENT_DOCK_DATE IMPLEMENT_DOCK_DATE
, IMPLEMENT_STATUS_CODE IMPLEMENT_STATUS_CODE
, IMPLEMENT_EMPLOYEE_ID IMPLEMENT_EMPLOYEE_ID
, IMPLEMENT_UOM_CODE IMPLEMENT_UOM_CODE
, IMPLEMENT_LOCATION_ID IMPLEMENT_LOCATION_ID
, IMPLEMENT_SOURCE_ORG_ID IMPLEMENT_SOURCE_ORG_ID
, IMPLEMENT_VENDOR_ID IMPLEMENT_VENDOR_ID
, IMPLEMENT_VENDOR_SITE_ID IMPLEMENT_VENDOR_SITE_ID
, RELEASE_STATUS RELEASE_STATUS
, LOAD_TYPE LOAD_TYPE
, IMPLEMENT_AS IMPLEMENT_AS
, DEMAND_CLASS DEMAND_CLASS
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, LINE_ID LINE_ID
, SOURCE SOURCE
, BY_PRODUCT_USING_ASSY_ID BY_PRODUCT_USING_ASSY_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_VENDOR_SITE_ID SOURCE_VENDOR_SITE_ID
, SOURCE_VENDOR_ID SOURCE_VENDOR_ID
, SOURCE_SUPPLY_SCHEDULE_NAME SOURCE_SUPPLY_SCHEDULE_NAME
, NEW_SHIP_DATE NEW_SHIP_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
, IMPLEMENT_PROJECT_ID IMPLEMENT_PROJECT_ID
, IMPLEMENT_TASK_ID IMPLEMENT_TASK_ID
, IMPLEMENT_SCHEDULE_GROUP_ID IMPLEMENT_SCHEDULE_GROUP_ID
, IMPLEMENT_BUILD_SEQUENCE IMPLEMENT_BUILD_SEQUENCE
, IMPLEMENT_ALTERNATE_BOM IMPLEMENT_ALTERNATE_BOM
, IMPLEMENT_ALTERNATE_ROUTING IMPLEMENT_ALTERNATE_ROUTING
, IMPLEMENT_LINE_ID IMPLEMENT_LINE_ID
, SOURCE_ITEM_ID SOURCE_ITEM_ID
, RELEASE_ERRORS RELEASE_ERRORS
, NUMBER1 NUMBER1
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, IMPLEMENT_END_ITEM_UNIT_NUMBER IMPLEMENT_END_ITEM_UNIT_NUMBER
FROM "MRP"."MRP_RECOMMENDATIONS"