View: MSD_SR_MFG_FCST_V

Product:	MSD - Demand Planning
Description:	This is the Source View for Manufacturing Forecast. This view would be applied to an Oracle Applications 11i instance from which the Manufacturing Forecast information is to be retrieved.
Implementation/DBA Data:	APPS.MSD_SR_MFG_FCST_V

View Text

SELECT MFD.FORECAST_DESIGNATOR
, NVL(MFD.ORGANIZATION_ID
, MSD_SR_UTIL.GET_NULL_PK)
, NULL
, NVL(MFD.INVENTORY_ITEM_ID
, MSD_SR_UTIL.GET_NULL_PK)
, NULL
, NVL(CUST.CUSTOMER_ID
, MSD_SR_UTIL.GET_NULL_PK)
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, NULL
, NVL(PRS.SITE_USE_ID
, MSD_SR_UTIL.GET_NULL_PK)
, NULL
, MFD.BUCKET_TYPE
, MFD.FORECAST_DATE
, MFD.RATE_END_DATE
, MFD.ORIGINAL_FORECAST_QUANTITY
, MFD.CURRENT_FORECAST_QUANTITY
, MSD_SR_UTIL.GET_NULL_PK
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, NULL
FROM MSD_APP_INSTANCE_ORGS MORG
, MTL_SYSTEM_ITEMS ITM
, MRP_FORECAST_DESIGNATORS MFDE
, MRP_FORECAST_DATES MFD
, RA_CUSTOMERS CUST
, RA_SITE_USES_ALL PRS
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE MFDE.FORECAST_DESIGNATOR = MFD.FORECAST_DESIGNATOR
AND MFDE.ORGANIZATION_ID = MFD.ORGANIZATION_ID
AND MFD.ORGANIZATION_ID = MORG.ORGANIZATION_ID
AND MFD.ORGANIZATION_ID = ITM.ORGANIZATION_ID
AND MFD.INVENTORY_ITEM_ID = ITM.INVENTORY_ITEM_ID
AND PRS.SITE_USE_ID (+)= MFDE.SHIP_ID
AND PRS.SITE_USE_CODE (+) = 'SHIP_TO'
AND ITM.ATO_FORECAST_CONTROL <> 3
AND ITM.MRP_PLANNING_CODE <> 6
AND CUST.CUSTOMER_ID (+)= MFDE.CUSTOMER_ID
AND MFD.ORIGINATION_TYPE <> 10
AND DECODE(DECODE(LOWER(FILTERCUST.PARAMETER_VALUE)
, NULL
, '1'
, DECODE(MFDE.CUSTOMER_ID
, NULL
, '1'
, LOWER(FILTERCUST.PARAMETER_VALUE)) )
, '1'
, '1'
, 'ATTRIBUTE1'
, CUST.ATTRIBUTE1
, 'ATTRIBUTE2'
, CUST.ATTRIBUTE2
, 'ATTRIBUTE3'
, CUST.ATTRIBUTE3
, 'ATTRIBUTE4'
, CUST.ATTRIBUTE4
, 'ATTRIBUTE5'
, CUST.ATTRIBUTE5
, 'ATTRIBUTE6'
, CUST.ATTRIBUTE6
, 'ATTRIBUTE7'
, CUST.ATTRIBUTE7
, 'ATTRIBUTE8'
, CUST.ATTRIBUTE8
, 'ATTRIBUTE9'
, CUST.ATTRIBUTE9
, 'ATTRIBUTE10'
, CUST.ATTRIBUTE10
, 'ATTRIBUTE11'
, CUST.ATTRIBUTE11
, 'ATTRIBUTE12'
, CUST.ATTRIBUTE12
, 'ATTRIBUTE13'
, CUST.ATTRIBUTE13
, 'ATTRIBUTE14'
, CUST.ATTRIBUTE14
, 'ATTRIBUTE15'
, CUST.ATTRIBUTE15
, '2') = '1'

Columns