View: MRP_LINE_SCHEDULES_V

Product:	MRP - Master Scheduling/MRP
Description:	This view is the base table view for the line scheduling detailswindow in MRPSLSWB.
Implementation/DBA Data:	APPS.MRP_LINE_SCHEDULES_V

View Text

SELECT REP.ROWID
, 3
, /* REPETITIVE */ TO_NUMBER(NULL)
, /* SCHEDULED_FLAG */ REP.WIP_ENTITY_ID
, ML.MEANING
, REP.ORGANIZATION_ID
, REP.LAST_UPDATE_DATE
, REP.LAST_UPDATED_BY
, REP.CREATION_DATE
, REP.CREATED_BY
, REP.LAST_UPDATE_LOGIN
, REP.REQUEST_ID
, REP.PROGRAM_APPLICATION_ID
, REP.PROGRAM_ID
, REP.PROGRAM_UPDATE_DATE
, REPITEM.PRIMARY_ITEM_ID
, KFV.CONCATENATED_SEGMENTS
, REPITEM.CLASS_CODE
, BOM.CALENDAR_DATE
, /* SCHEDULED_START_DATE */ REP.DATE_CLOSED
, 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) )
, TO_DATE(NULL)
, /* MPS_SCHEDULED_COMPLETION_DATE */ TO_NUMBER(NULL)
, /* MPS_NET_QUANTITY */ REP.BOM_REVISION
, REP.ROUTING_REVISION
, REP.BOM_REVISION_DATE
, REP.ROUTING_REVISION_DATE
, REP.ALTERNATE_BOM_DESIGNATOR
, REP.ALTERNATE_ROUTING_DESIGNATOR
, REPITEM.COMPLETION_SUBINVENTORY
, REPITEM.COMPLETION_LOCATOR_ID
, REP.MATERIAL_ACCOUNT
, REP.MATERIAL_OVERHEAD_ACCOUNT
, REP.RESOURCE_ACCOUNT
, REP.OUTSIDE_PROCESSING_ACCOUNT
, REP.MATERIAL_VARIANCE_ACCOUNT
, REP.RESOURCE_VARIANCE_ACCOUNT
, REP.OUTSIDE_PROC_VARIANCE_ACCOUNT
, TO_NUMBER(NULL)
, /* STD_COST_ADJUSTMENT_ACCOUNT */ REP.OVERHEAD_ACCOUNT
, REP.OVERHEAD_VARIANCE_ACCOUNT
, REP.DEMAND_CLASS
, BOM.CALENDAR_DATE
, /* SCHEDULED_COMPLETION_DATE */ TO_NUMBER(NULL)
, /* SCHEDULE_GROUP_ID */ NULL
, /* SCHEDULE_GROUP_NAME */ TO_NUMBER(NULL)
, /* BUILD_SEQUENCE */ REP.LINE_ID
, LINE.LINE_CODE
, TO_NUMBER(NULL)
, /* PROJECT_ID */ NULL
, /* PROJECT_NAME */ TO_NUMBER(NULL)
, /* TASK_ID */ NULL
, /* TASK_NAME */ REP.STATUS_TYPE
, WJS.MEANING
, /* STATUS_TYPE_TEXT */ NULL
, /* ATTRIBUTE_CATEGORY */ NULL
, /* ATTRIBUTE1 */ NULL
, /* ATTRIBUTE2 */ NULL
, /* ATTRIBUTE3 */ NULL
, /* ATTRIBUTE4 */ NULL
, /* ATTRIBUTE5 */ NULL
, /* ATTRIBUTE6 */ NULL
, /* ATTRIBUTE7 */ NULL
, /* ATTRIBUTE8 */ NULL
, /* ATTRIBUTE9 */ NULL
, /* ATTRIBUTE10 */ NULL
, /* ATTRIBUTE11 */ NULL
, /* ATTRIBUTE12 */ NULL
, /* ATTRIBUTE13 */ NULL
, /* ATTRIBUTE14 */ NULL
, /* ATTRIBUTE15 */ TO_NUMBER(NULL)
, /* DEMAND_SOURCE_HEADER_ID */ NULL
, /* DEMAND_SOURCE_LINE */ TO_NUMBER(NULL)
, /* SO_LINE_NUMBER */ TO_DATE(NULL)
, /* SO_PROMISED_DATE */ TO_DATE(NULL)
, /* SO_SCHEDULED_DATE */ TO_DATE(NULL)
, /* SO_REQUESTED_DATE */ TO_NUMBER(NULL)
, NULL
, /* DEMAND_SOURCE_DELIVERY */ TO_NUMBER(NULL)
, /* DEMAND_SOURCE_TYPE */ TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, WST.MEANING
, KFV.REPLENISH_TO_ORDER_FLAG
, KFV.BUILD_IN_WIP_FLAG
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MFG_LOOKUPS WST
, MFG_LOOKUPS ML
, MFG_LOOKUPS WJS
, WIP_ENTITIES ENTITIES
, MTL_SYSTEM_ITEMS_KFV KFV
, MTL_PARAMETERS MP
, BOM_CALENDAR_DATES BOM
, WIP_REPETITIVE_ITEMS REPITEM
, WIP_LINES LINE
, WIP_REPETITIVE_SCHEDULES REP
WHERE WST.LOOKUP_CODE = 3
AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'
AND ML.LOOKUP_TYPE = 'MRP_WORKBENCH_IMPLEMENT_AS'
AND ML.LOOKUP_CODE = 4
AND WJS.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND WJS.LOOKUP_CODE = REP.STATUS_TYPE
AND ENTITIES.WIP_ENTITY_ID = REP.WIP_ENTITY_ID
AND KFV.INVENTORY_ITEM_ID = REPITEM.PRIMARY_ITEM_ID
AND KFV.ORGANIZATION_ID = REPITEM.ORGANIZATION_ID
AND 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 LINE.ORGANIZATION_ID = REP.ORGANIZATION_ID
AND LINE.LINE_ID = REP.LINE_ID UNION ALL SELECT JOB.ROWID
, 1
, /* JOB */ TO_NUMBER(NULL)
, /* SCHEDULED_FLAG */ JOB.WIP_ENTITY_ID
, ENTITIES.WIP_ENTITY_NAME
, JOB.ORGANIZATION_ID
, JOB.LAST_UPDATE_DATE
, JOB.LAST_UPDATED_BY
, JOB.CREATION_DATE
, JOB.CREATED_BY
, JOB.LAST_UPDATE_LOGIN
, JOB.REQUEST_ID
, JOB.PROGRAM_APPLICATION_ID
, JOB.PROGRAM_ID
, JOB.PROGRAM_UPDATE_DATE
, JOB.PRIMARY_ITEM_ID
, KFV.CONCATENATED_SEGMENTS
, JOB.CLASS_CODE
, JOB.SCHEDULED_START_DATE
, JOB.DATE_CLOSED
, JOB.START_QUANTITY
, JOB.QUANTITY_COMPLETED
, JOB.MPS_SCHEDULED_COMPLETION_DATE
, JOB.MPS_NET_QUANTITY
, JOB.BOM_REVISION
, JOB.ROUTING_REVISION
, JOB.BOM_REVISION_DATE
, JOB.ROUTING_REVISION_DATE
, JOB.ALTERNATE_BOM_DESIGNATOR
, JOB.ALTERNATE_ROUTING_DESIGNATOR
, JOB.COMPLETION_SUBINVENTORY
, JOB.COMPLETION_LOCATOR_ID
, JOB.MATERIAL_ACCOUNT
, JOB.MATERIAL_OVERHEAD_ACCOUNT
, JOB.RESOURCE_ACCOUNT
, JOB.OUTSIDE_PROCESSING_ACCOUNT
, JOB.MATERIAL_VARIANCE_ACCOUNT
, JOB.RESOURCE_VARIANCE_ACCOUNT
, JOB.OUTSIDE_PROC_VARIANCE_ACCOUNT
, JOB.STD_COST_ADJUSTMENT_ACCOUNT
, JOB.OVERHEAD_ACCOUNT
, JOB.OVERHEAD_VARIANCE_ACCOUNT
, JOB.DEMAND_CLASS
, JOB.SCHEDULED_COMPLETION_DATE
, JOB.SCHEDULE_GROUP_ID
, SCH.SCHEDULE_GROUP_NAME
, JOB.BUILD_SEQUENCE
, JOB.LINE_ID
, LINE.LINE_CODE
, JOB.PROJECT_ID
, MRP_GET_PROJECT.PROJECT(JOB.PROJECT_ID)
, JOB.TASK_ID
, MRP_GET_PROJECT.TASK(JOB.TASK_ID)
, JOB.STATUS_TYPE
, WJS.MEANING
, NULL
, /* ATTRIBUTE_CATEGORY */ NULL
, /* ATTRIBUTE1 */ NULL
, /* ATTRIBUTE2 */ NULL
, /* ATTRIBUTE3 */ NULL
, /* ATTRIBUTE4 */ NULL
, /* ATTRIBUTE5 */ NULL
, /* ATTRIBUTE6 */ NULL
, /* ATTRIBUTE7 */ NULL
, /* ATTRIBUTE8 */ NULL
, /* ATTRIBUTE9 */ NULL
, /* ATTRIBUTE10 */ NULL
, /* ATTRIBUTE11 */ NULL
, /* ATTRIBUTE12 */ NULL
, /* ATTRIBUTE13 */ NULL
, /* ATTRIBUTE14 */ NULL
, /* ATTRIBUTE15 */ WSA.DEMAND_SOURCE_HEADER_ID
, WSA.DEMAND_SOURCE_LINE
, SO_LINES.LINE_NUMBER
, SO_LINES.PROMISE_DATE
, SO_LINES.SCHEDULE_SHIP_DATE
, SO_LINES.REQUEST_DATE
, SO_LINES.PLANNING_PRIORITY
, WSA.DEMAND_SOURCE_DELIVERY
, TO_NUMBER(NULL) /* DEMAND_SOURCE_TYPE */
, (TRUNC(JOB.SCHEDULED_COMPLETION_DATE) - TRUNC(SO_LINES.REQUEST_DATE))
, JOB.END_ITEM_UNIT_NUMBER
, JOB.QUANTITY_SCRAPPED
, WST.MEANING
, KFV.REPLENISH_TO_ORDER_FLAG
, KFV.BUILD_IN_WIP_FLAG
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MFG_LOOKUPS WST
, OE_ORDER_LINES_ALL SO_LINES
, WIP_SO_ALLOCATIONS WSA
, WIP_SCHEDULE_GROUPS SCH
, MFG_LOOKUPS WJS
, WIP_ENTITIES ENTITIES
, MTL_SYSTEM_ITEMS_KFV KFV
, WIP_DISCRETE_JOBS JOB
, WIP_LINES LINE
WHERE WST.LOOKUP_CODE = 1
AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'
AND SO_LINES.LINE_ID(+) = TO_NUMBER(WSA.DEMAND_SOURCE_LINE)
AND WSA.WIP_ENTITY_ID(+) = JOB.WIP_ENTITY_ID
AND WSA.ORGANIZATION_ID(+) = JOB.ORGANIZATION_ID
AND SCH.SCHEDULE_GROUP_ID(+)= JOB.SCHEDULE_GROUP_ID
AND SCH.ORGANIZATION_ID(+) = JOB.ORGANIZATION_ID
AND WJS.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND WJS.LOOKUP_CODE = JOB.STATUS_TYPE
AND ENTITIES.ORGANIZATION_ID = JOB.ORGANIZATION_ID
AND ENTITIES.WIP_ENTITY_ID = JOB.WIP_ENTITY_ID
AND KFV.INVENTORY_ITEM_ID = JOB.PRIMARY_ITEM_ID
AND KFV.ORGANIZATION_ID = JOB.ORGANIZATION_ID
AND JOB.LINE_ID = LINE.LINE_ID
AND JOB.ORGANIZATION_ID = LINE.ORGANIZATION_ID UNION ALL SELECT FLOW.ROWID
, 2
, /* FLOW */ FLOW.SCHEDULED_FLAG
, FLOW.WIP_ENTITY_ID
, FLOW.SCHEDULE_NUMBER
, FLOW.ORGANIZATION_ID
, FLOW.LAST_UPDATE_DATE
, FLOW.LAST_UPDATED_BY
, FLOW.CREATION_DATE
, FLOW.CREATED_BY
, FLOW.LAST_UPDATE_LOGIN
, FLOW.REQUEST_ID
, FLOW.PROGRAM_APPLICATION_ID
, FLOW.PROGRAM_ID
, FLOW.PROGRAM_UPDATE_DATE
, FLOW.PRIMARY_ITEM_ID
, KFV.CONCATENATED_SEGMENTS
, FLOW.CLASS_CODE
, FLOW.SCHEDULED_START_DATE
, FLOW.DATE_CLOSED
, FLOW.PLANNED_QUANTITY
, FLOW.QUANTITY_COMPLETED
, FLOW.MPS_SCHEDULED_COMPLETION_DATE
, FLOW.MPS_NET_QUANTITY
, FLOW.BOM_REVISION
, FLOW.ROUTING_REVISION
, FLOW.BOM_REVISION_DATE
, FLOW.ROUTING_REVISION_DATE
, FLOW.ALTERNATE_BOM_DESIGNATOR
, FLOW.ALTERNATE_ROUTING_DESIGNATOR
, FLOW.COMPLETION_SUBINVENTORY
, FLOW.COMPLETION_LOCATOR_ID
, FLOW.MATERIAL_ACCOUNT
, FLOW.MATERIAL_OVERHEAD_ACCOUNT
, FLOW.RESOURCE_ACCOUNT
, FLOW.OUTSIDE_PROCESSING_ACCOUNT
, FLOW.MATERIAL_VARIANCE_ACCOUNT
, FLOW.RESOURCE_VARIANCE_ACCOUNT
, FLOW.OUTSIDE_PROC_VARIANCE_ACCOUNT
, FLOW.STD_COST_ADJUSTMENT_ACCOUNT
, FLOW.OVERHEAD_ACCOUNT
, FLOW.OVERHEAD_VARIANCE_ACCOUNT
, FLOW.DEMAND_CLASS
, FLOW.SCHEDULED_COMPLETION_DATE
, FLOW.SCHEDULE_GROUP_ID
, SCH.SCHEDULE_GROUP_NAME
, FLOW.BUILD_SEQUENCE
, FLOW.LINE_ID
, LINE.LINE_CODE
, FLOW.PROJECT_ID
, MRP_GET_PROJECT.PROJECT(FLOW.PROJECT_ID)
, FLOW.TASK_ID
, MRP_GET_PROJECT.TASK(FLOW.TASK_ID)
, FLOW.STATUS
, ST.MEANING
, FLOW.ATTRIBUTE_CATEGORY
, FLOW.ATTRIBUTE1
, FLOW.ATTRIBUTE2
, FLOW.ATTRIBUTE3
, FLOW.ATTRIBUTE4
, FLOW.ATTRIBUTE5
, FLOW.ATTRIBUTE6
, FLOW.ATTRIBUTE7
, FLOW.ATTRIBUTE8
, FLOW.ATTRIBUTE9
, FLOW.ATTRIBUTE10
, FLOW.ATTRIBUTE11
, FLOW.ATTRIBUTE12
, FLOW.ATTRIBUTE13
, FLOW.ATTRIBUTE14
, FLOW.ATTRIBUTE15
, FLOW.DEMAND_SOURCE_HEADER_ID
, FLOW.DEMAND_SOURCE_LINE
, SO_LINES.LINE_NUMBER
, SO_LINES.PROMISE_DATE
, SO_LINES.SCHEDULE_SHIP_DATE
, SO_LINES.REQUEST_DATE
, SO_LINES.PLANNING_PRIORITY
, DEMAND_SOURCE_DELIVERY
, DEMAND_SOURCE_TYPE
, (TRUNC(FLOW.SCHEDULED_COMPLETION_DATE) - TRUNC(SO_LINES.REQUEST_DATE))
, FLOW.END_ITEM_UNIT_NUMBER
, FLOW.QUANTITY_SCRAPPED
, WST.MEANING
, KFV.REPLENISH_TO_ORDER_FLAG
, KFV.BUILD_IN_WIP_FLAG
, FLOW.ROLL_FORWARDED_FLAG
, FLOW.KANBAN_CARD_ID
FROM MFG_LOOKUPS WST
, OE_ORDER_LINES_ALL SO_LINES
, WIP_SCHEDULE_GROUPS SCH
, MTL_SYSTEM_ITEMS_KFV KFV
, WIP_FLOW_SCHEDULES FLOW
, WIP_LINES LINE
, MFG_LOOKUPS ST
WHERE WST.LOOKUP_CODE = 2
AND WST.LOOKUP_TYPE = 'MRP_WIP_SCHEDULE_TYPE'
AND SO_LINES.LINE_ID(+) = TO_NUMBER(FLOW.DEMAND_SOURCE_LINE)
AND SCH.SCHEDULE_GROUP_ID(+) = FLOW.SCHEDULE_GROUP_ID
AND SCH.ORGANIZATION_ID(+) = FLOW.ORGANIZATION_ID
AND KFV.INVENTORY_ITEM_ID = FLOW.PRIMARY_ITEM_ID
AND KFV.ORGANIZATION_ID = FLOW.ORGANIZATION_ID
AND FLOW.LINE_ID = LINE.LINE_ID
AND FLOW.ORGANIZATION_ID = LINE.ORGANIZATION_ID
AND ST.LOOKUP_TYPE = 'WIP_FLOW_SCHEDULE_STATUS'
AND ST.LOOKUP_CODE = FLOW.STATUS

Columns