eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRP_SCHEDULE_ITEM_DATES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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