VIEW: APPS.MRP_LINE_SCH_AVAIL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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