View: MRP_SCHEDULE_DATES_V

Product:	MRP - Master Scheduling/MRP
Description:	Schedule entries view
Implementation/DBA Data:	APPS.MRP_SCHEDULE_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.INVENTORY_ITEM_ID
, MRSDA.ORGANIZATION_ID
, MRSDA.SCHEDULE_DESIGNATOR
, 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
, PARAM.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
, 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
FROM WIP_LINES WIP
, MTL_SYSTEM_ITEMS MSI
, MTL_PARAMETERS PARAM
, MFG_LOOKUPS L
, MRP_SCHEDULE_CONSUMPTIONS MRSC
, 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 PARAM.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 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.INVENTORY_ITEM_ID
, MRSDA.ORGANIZATION_ID
, MRSDA.SCHEDULE_DESIGNATOR
, 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
, PARAM.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
, 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

Columns