View: MRP_LINE_SCH_AVAIL_V

Product:	MRP - Master Scheduling/MRP
Description:	This view is a simplified version of view MRP_LINE_SCHEDULES_V.
Implementation/DBA Data:	APPS.MRP_LINE_SCH_AVAIL_V

View Text

SELECT 3
, REP.WIP_ENTITY_ID
, REP.ORGANIZATION_ID
, REPITEM.PRIMARY_ITEM_ID
, REP.LINE_ID
, REP.DAILY_PRODUCTION_RATE
, (REP.DAILY_PRODUCTION_RATE - MRP_HORIZONTAL_PLAN_SC.COMPUTE_DAILY_RATE_T ( BOM.CALENDAR_CODE
, BOM.EXCEPTION_SET_ID
, REP.DAILY_PRODUCTION_RATE
, REP.QUANTITY_COMPLETED
, REP.FIRST_UNIT_COMPLETION_DATE
, BOM.CALENDAR_DATE) )
, BOM.CALENDAR_DATE
, REP.ALTERNATE_ROUTING_DESIGNATOR
FROM BOM_CALENDAR_DATES BOM
, WIP_REPETITIVE_ITEMS REPITEM
, WIP_REPETITIVE_SCHEDULES REP
, MTL_PARAMETERS MP
WHERE BOM.CALENDAR_DATE BETWEEN TRUNC(REP.FIRST_UNIT_COMPLETION_DATE)
AND TRUNC(REP.LAST_UNIT_COMPLETION_DATE)
AND BOM.SEQ_NUM IS NOT NULL
AND MP.CALENDAR_CODE = BOM.CALENDAR_CODE
AND MP.CALENDAR_EXCEPTION_SET_ID = BOM.EXCEPTION_SET_ID
AND MP.ORGANIZATION_ID = REP.ORGANIZATION_ID
AND REPITEM.LINE_ID = REP.LINE_ID
AND REPITEM.WIP_ENTITY_ID = REP.WIP_ENTITY_ID
AND REPITEM.ORGANIZATION_ID = REP.ORGANIZATION_ID
AND REPITEM.LINE_ID IS NOT NULL UNION ALL SELECT 1
, JOB.WIP_ENTITY_ID
, JOB.ORGANIZATION_ID
, JOB.PRIMARY_ITEM_ID
, JOB.LINE_ID
, JOB.START_QUANTITY
, JOB.QUANTITY_COMPLETED
, JOB.SCHEDULED_COMPLETION_DATE
, JOB.ALTERNATE_ROUTING_DESIGNATOR
FROM WIP_DISCRETE_JOBS JOB
WHERE JOB.LINE_ID IS NOT NULL UNION ALL SELECT 2
, FLOW.WIP_ENTITY_ID
, FLOW.ORGANIZATION_ID
, FLOW.PRIMARY_ITEM_ID
, FLOW.LINE_ID
, FLOW.PLANNED_QUANTITY
, FLOW.QUANTITY_COMPLETED
, FLOW.SCHEDULED_COMPLETION_DATE
, FLOW.ALTERNATE_ROUTING_DESIGNATOR
FROM WIP_FLOW_SCHEDULES FLOW
WHERE FLOW.LINE_ID IS NOT NULL

Columns