[Home] [Help]
View: MRP_KANBAN_ACTUAL_PROD_V
Product: | MRP - Master Scheduling/MRP |
Description: | This view is used by the kanban planning engine to get the actual production demand for discrete jobs, repetitive schedules and flow schedules. |
Implementation/DBA Data: |
APPS.MRP_KANBAN_ACTUAL_PROD_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_BOM_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 REP.STATUS_TYPE IN (1
, 3
, 6)
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_BOM_DESIGNATOR
FROM WIP_DISCRETE_JOBS JOB
WHERE STATUS_TYPE IN (1
, 3
, 6
, 16) 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_BOM_DESIGNATOR
FROM WIP_FLOW_SCHEDULES FLOW
WHERE FLOW.LINE_ID IS NOT NULL
AND FLOW.STATUS = 1
Columns
Name |
SCHEDULE_TYPE |
WIP_ENTITY_ID |
ORGANIZATION_ID |
PRIMARY_ITEM_ID |
LINE_ID |
PLANNED_QUANTITY |
QUANTITY_COMPLETED |
SCHEDULED_COMPLETION_DATE |
ALTERNATE_BOM_DESIGNATOR |