View: MRP_SCHEDULE_ITEM_DATES_V

Product:	MRP - Master Scheduling/MRP
Description:	Master schedule entries view
Implementation/DBA Data:	APPS.MRP_SCHEDULE_ITEM_DATES_V

View Text

SELECT MRSDA.ROWID ROW_ID
, MRSDA.MPS_TRANSACTION_ID
, MRSDA.SCHEDULE_LEVEL
, DECODE(COUNT(MRSC.TRANSACTION_ID)
, 0
, 'N'
, 'Y') RELIEF_FLAG
, MRSDA.SUPPLY_DEMAND_TYPE
, MRSDA.LAST_UPDATE_DATE
, MRSDA.LAST_UPDATED_BY
, MRSDA.CREATION_DATE
, MRSDA.CREATED_BY
, MRSDA.LAST_UPDATE_LOGIN
, MRSDA.ORGANIZATION_ID
, MRSDA.SCHEDULE_DESIGNATOR
, MRSDA.INVENTORY_ITEM_ID
, NVL(MSI.DEMAND_TIME_FENCE_DAYS
, 0) DEMAND_TIME_FENCE_DAYS
, NVL(MSI.PLANNING_TIME_FENCE_DAYS
, 0) PLANNING_TIME_FENCE_DAYS
, DECODE(MRSDE.SCHEDULE_TYPE
, 1
, DECODE(MSI.DEMAND_TIME_FENCE_DAYS
, NULL
, TO_DATE(NULL)
, CAL2.CALENDAR_DATE)
, 2
, TO_DATE(NULL)) DEMAND_TIME_FENCE_DATE
, DECODE(MRSDE.SCHEDULE_TYPE
, 1
, TO_DATE(NULL)
, 2
, DECODE(MSI.PLANNING_TIME_FENCE_DAYS
, NULL
, TO_DATE( NULL)
, CAL2.CALENDAR_DATE)) PLANNING_TIME_FENCE_DATE
, NVL(MSI.REPETITIVE_PLANNING_FLAG
, 'N') REPETITIVE_PLANNING_FLAG
, MSI.BOM_ITEM_TYPE
, MSI.MRP_PLANNING_CODE
, MRSDA.SCHEDULE_DATE
, MRSDA.SCHEDULE_WORKDATE
, MRSDA.RATE_END_DATE
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, NULL
, MRSDA.SCHEDULE_QUANTITY) SCHEDULE_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, MRSDA.SCHEDULE_QUANTITY)) ORIGINAL_QUANTITY
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, NULL) REPETITIVE_DAILY_RATE
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY) QUANTITY_OR_RATE
, MRSDA.SCHEDULE_ORIGINATION_TYPE
, L.MEANING SCHEDULE_ORIGINATION_TEXT
, MRSDA.SOURCE_FORECAST_DESIGNATOR
, MRSDA.REFERENCE_SCHEDULE_ID
, MRSDA.SCHEDULE_COMMENTS
, MRSDA.SOURCE_ORGANIZATION_ID
, PARAM2.ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
, MRSDA.SOURCE_SCHEDULE_DESIGNATOR
, MRSDA.SOURCE_SALES_ORDER_ID
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 1
, NULL
, NVL(MRSDA.SOURCE_FORECAST_DESIGNATOR
, MRSDA.SOURCE_SCHEDULE_DESIGNATOR)) SOURCE_DESIGNATOR
, MRSDA.SOURCE_CODE
, MRSDA.SOURCE_LINE_ID
, MRSDA.RESERVATION_ID
, MRSDA.FORECAST_ID
, NVL(RSI.IN_SOURCE_PLAN
, 2) IN_SOURCE_PLAN
, MRSDA.REQUEST_ID
, MRSDA.PROGRAM_APPLICATION_ID
, MRSDA.PROGRAM_ID
, MRSDA.PROGRAM_UPDATE_DATE
, MRSDA.DDF_CONTEXT
, MRSDA.ATTRIBUTE_CATEGORY
, MRSDA.ATTRIBUTE1
, MRSDA.ATTRIBUTE2
, MRSDA.ATTRIBUTE3
, MRSDA.ATTRIBUTE4
, MRSDA.ATTRIBUTE5
, MRSDA.ATTRIBUTE6
, MRSDA.ATTRIBUTE7
, MRSDA.ATTRIBUTE8
, MRSDA.ATTRIBUTE9
, MRSDA.ATTRIBUTE10
, MRSDA.ATTRIBUTE11
, MRSDA.ATTRIBUTE12
, MRSDA.ATTRIBUTE13
, MRSDA.ATTRIBUTE14
, MRSDA.ATTRIBUTE15
, MRSDA.PROJECT_ID
, MRP_GET_PROJECT.PROJECT(MRSDA.PROJECT_ID)
, MRSDA.TASK_ID
, MRP_GET_PROJECT.TASK(MRSDA.TASK_ID)
, MRSDA.LINE_ID
, WIP.LINE_CODE
, MRSDA.END_ITEM_UNIT_NUMBER
, MSI.CONCATENATED_SEGMENTS
FROM WIP_LINES WIP
, BOM_CALENDAR_DATES CAL1
, BOM_CALENDAR_DATES CAL2
, MRP_SYSTEM_ITEMS RSI
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PARAMETERS PARAM2
, MTL_PARAMETERS PARAM
, MFG_LOOKUPS L
, MRP_SCHEDULE_CONSUMPTIONS MRSC
, MRP_SCHEDULE_DESIGNATORS MRSDE
, MRP_ORGANIZATIONS_V MO
, MRP_SCHEDULE_DATES MRSDA
WHERE WIP.LINE_ID(+) = MRSDA.LINE_ID
AND WIP.ORGANIZATION_ID(+) = MRSDA.ORGANIZATION_ID
AND L.LOOKUP_TYPE = 'MRP_SCHEDULE_ORIG'
AND L.LOOKUP_CODE = MRSDA.SCHEDULE_ORIGINATION_TYPE
AND PARAM2.ORGANIZATION_ID(+) = MRSDA.SOURCE_ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = MRSDA.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MRSDA.INVENTORY_ITEM_ID
AND MRSC.TRANSACTION_ID(+) = MRSDA.MPS_TRANSACTION_ID
AND PARAM.ORGANIZATION_ID = MRSDA.ORGANIZATION_ID
AND CAL2.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND CAL2.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND MRSDE.SCHEDULE_DESIGNATOR = MO.COMPILE_DESIGNATOR(+)
AND MRSDE.ORGANIZATION_ID = MO.ORGANIZATION_ID(+)
AND NVL(MO.PLANNED_ORGANIZATION
, MRSDE.ORGANIZATION_ID) = MRSDA.ORGANIZATION_ID
AND MRSDE.SCHEDULE_DESIGNATOR = MRSDA.SCHEDULE_DESIGNATOR
AND MRSDA.ORGANIZATION_ID = RSI.ORGANIZATION_ID(+)
AND MRSDA.SCHEDULE_DESIGNATOR = RSI.COMPILE_DESIGNATOR(+)
AND MRSDA.INVENTORY_ITEM_ID = RSI.INVENTORY_ITEM_ID(+)
AND CAL2.SEQ_NUM = CAL1.PRIOR_SEQ_NUM + DECODE(MRSDE.SCHEDULE_TYPE
, 1
, NVL(MSI.DEMAND_TIME_FENCE_DAYS
, 0)
, 2
, NVL(MSI.PLANNING_TIME_FENCE_DAYS
, 0))
AND CAL1.EXCEPTION_SET_ID = PARAM.CALENDAR_EXCEPTION_SET_ID
AND CAL1.CALENDAR_CODE = PARAM.CALENDAR_CODE
AND CAL1.CALENDAR_DATE = TRUNC(SYSDATE) GROUP BY MRSDA.ROWID
, MRSDA.MPS_TRANSACTION_ID
, MRSDA.SCHEDULE_LEVEL
, MRSDA.SUPPLY_DEMAND_TYPE
, MRSDA.LAST_UPDATE_DATE
, MRSDA.LAST_UPDATED_BY
, MRSDA.CREATION_DATE
, MRSDA.CREATED_BY
, MRSDA.LAST_UPDATE_LOGIN
, MRSDA.ORGANIZATION_ID
, MRSDA.SCHEDULE_DESIGNATOR
, MRSDA.INVENTORY_ITEM_ID
, NVL(MSI.DEMAND_TIME_FENCE_DAYS
, 0)
, NVL(MSI.PLANNING_TIME_FENCE_DAYS
, 0)
, DECODE(MRSDE.SCHEDULE_TYPE
, 1
, DECODE(MSI.DEMAND_TIME_FENCE_DAYS
, NULL
, TO_DATE( NULL)
, CAL2.CALENDAR_DATE)
, 2
, TO_DATE( NULL))
, DECODE(MRSDE.SCHEDULE_TYPE
, 1
, TO_DATE( NULL)
, 2
, DECODE(MSI.PLANNING_TIME_FENCE_DAYS
, NULL
, TO_DATE( NULL)
, CAL2.CALENDAR_DATE))
, NVL(MSI.REPETITIVE_PLANNING_FLAG
, 'N')
, MSI.BOM_ITEM_TYPE
, MSI.MRP_PLANNING_CODE
, MRSDA.SCHEDULE_DATE
, MRSDA.SCHEDULE_WORKDATE
, MRSDA.RATE_END_DATE
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, NULL
, MRSDA.SCHEDULE_QUANTITY)
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, NVL(MRSDA.ORIGINAL_SCHEDULE_QUANTITY
, MRSDA.SCHEDULE_QUANTITY))
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, NULL)
, DECODE(MSI.REPETITIVE_PLANNING_FLAG
, 'Y'
, MRSDA.REPETITIVE_DAILY_RATE
, MRSDA.SCHEDULE_QUANTITY)
, MRSDA.SCHEDULE_ORIGINATION_TYPE
, L.MEANING
, MRSDA.SOURCE_FORECAST_DESIGNATOR
, MRSDA.REFERENCE_SCHEDULE_ID
, MRSDA.SCHEDULE_COMMENTS
, MRSDA.SOURCE_ORGANIZATION_ID
, PARAM2.ORGANIZATION_CODE
, MRSDA.SOURCE_SCHEDULE_DESIGNATOR
, MRSDA.SOURCE_SALES_ORDER_ID
, DECODE(MRSDA.SCHEDULE_ORIGINATION_TYPE
, 1
, NULL
, NVL(MRSDA.SOURCE_FORECAST_DESIGNATOR
, MRSDA.SOURCE_SCHEDULE_DESIGNATOR))
, MRSDA.SOURCE_CODE
, MRSDA.SOURCE_LINE_ID
, MRSDA.RESERVATION_ID
, MRSDA.FORECAST_ID
, NVL(RSI.IN_SOURCE_PLAN
, 2)
, MRSDA.REQUEST_ID
, MRSDA.PROGRAM_APPLICATION_ID
, MRSDA.PROGRAM_ID
, MRSDA.PROGRAM_UPDATE_DATE
, MRSDA.DDF_CONTEXT
, MRSDA.ATTRIBUTE_CATEGORY
, MRSDA.ATTRIBUTE1
, MRSDA.ATTRIBUTE2
, MRSDA.ATTRIBUTE3
, MRSDA.ATTRIBUTE4
, MRSDA.ATTRIBUTE5
, MRSDA.ATTRIBUTE6
, MRSDA.ATTRIBUTE7
, MRSDA.ATTRIBUTE8
, MRSDA.ATTRIBUTE9
, MRSDA.ATTRIBUTE10
, MRSDA.ATTRIBUTE11
, MRSDA.ATTRIBUTE12
, MRSDA.ATTRIBUTE13
, MRSDA.ATTRIBUTE14
, MRSDA.ATTRIBUTE15
, MRSDA.PROJECT_ID
, MRP_GET_PROJECT.PROJECT(MRSDA.PROJECT_ID)
, MRSDA.TASK_ID
, MRP_GET_PROJECT.TASK(MRSDA.TASK_ID)
, MRSDA.LINE_ID
, WIP.LINE_CODE
, MRSDA.END_ITEM_UNIT_NUMBER
, MSI.CONCATENATED_SEGMENTS

Columns