VIEW: APPS.MRP_LINE_SCHEDULES_V

Source

View Text - Preformatted

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), 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), 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, FLOW.ALLOCATED_FLAG 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

View Text - HTML Formatted

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)
, 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)
, 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
, FLOW.ALLOCATED_FLAG
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