VIEW: APPS.MRP_WIP_REP_SCHD_VIEW

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)