Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | WIP repetitive schedule supply view |
Implementation/DBA Data: | APPS.MRP_WIP_REP_SCHD_VIEW |
SELECT ITEMS.PRIMARY_ITEM_ID
, MRP_ITEMS.COMPILE_DESIGNATOR
, MRP_ITEMS.ORGANIZATION_ID
, SCHED.WIP_ENTITY_ID
, SCHED.REPETITIVE_SCHEDULE_ID
, SCHED.LINE_ID
, SCHED.FIRST_UNIT_START_DATE
, SCHED.FIRST_UNIT_COMPLETION_DATE
, SCHED.LAST_UNIT_START_DATE
, SCHED.LAST_UNIT_COMPLETION_DATE
, SCHED.PROCESSING_WORK_DAYS
, SCHED.DAILY_PRODUCTION_RATE
, SCHED.BOM_REVISION
, SCHED.STATUS_TYPE
, SCHED.FIRM_PLANNED_FLAG
, SCHED.QUANTITY_COMPLETED
, MRP_ITEMS.FULL_LEAD_TIME
, SCHED.DEMAND_CLASS
FROM MRP_SYSTEM_ITEMS MRP_ITEMS
, WIP_REPETITIVE_SCHEDULES SCHED
, WIP_REPETITIVE_ITEMS ITEMS
WHERE MRP_ITEMS.ORGANIZATION_ID = SCHED.ORGANIZATION_ID
AND MRP_ITEMS.INVENTORY_ITEM_ID = ITEMS.PRIMARY_ITEM_ID
AND ITEMS.ORGANIZATION_ID = SCHED.ORGANIZATION_ID
AND ITEMS.LINE_ID = SCHED.LINE_ID
AND ITEMS.WIP_ENTITY_ID = SCHED.WIP_ENTITY_ID
AND SCHED.STATUS_TYPE IN (1
, 3
, 6)
AND SCHED.LAST_UNIT_COMPLETION_DATE >= TRUNC(SYSDATE)