View: MRP_FORECAST_DATES_V

Product:	MRP - Master Scheduling/MRP
Description:	Forecast entries view
Implementation/DBA Data:	APPS.MRP_FORECAST_DATES_V

View Text

SELECT FDATE.ROWID
, FDATE.TRANSACTION_ID
, FDATE.LAST_UPDATE_DATE
, FDATE.LAST_UPDATED_BY
, FDATE.CREATION_DATE
, FDATE.CREATED_BY
, FDATE.LAST_UPDATE_LOGIN
, FDATE.INVENTORY_ITEM_ID
, FDATE.ORGANIZATION_ID
, FDATE.FORECAST_DESIGNATOR
, FDATE.FORECAST_DATE
, FDATE.ORIGINAL_FORECAST_QUANTITY
, FDATE.CURRENT_FORECAST_QUANTITY
, FDATE.CONFIDENCE_PERCENTAGE
, FDATE.BUCKET_TYPE
, FDATE.RATE_END_DATE
, FDATE.ORIGINATION_TYPE
, L1.MEANING
, FDATE.CUSTOMER_ID
, FDATE.SHIP_ID
, FDATE.BILL_ID
, FDATE.COMMENTS
, FDATE.SOURCE_ORGANIZATION_ID
, PARAM.ORGANIZATION_CODE
, FDATE.SOURCE_FORECAST_DESIGNATOR
, FDATE.SOURCE_CODE
, FDATE.SOURCE_LINE_ID
, FDATE.END_ITEM_ID
, FDATE.END_PLANNING_BOM_PERCENT
, FDATE.FORECAST_RULE_ID
, FDATE.DEMAND_USAGE_START_DATE
, FDATE.FORECAST_TREND
, FDATE.FOCUS_TYPE
, FDATE.FORECAST_MAD
, FDATE.DEMAND_CLASS
, FDATE.REQUEST_ID
, FDATE.PROGRAM_APPLICATION_ID
, FDATE.PROGRAM_ID
, FDATE.PROGRAM_UPDATE_DATE
, FDATE.DDF_CONTEXT
, FDATE.ATTRIBUTE_CATEGORY
, FDATE.ATTRIBUTE1
, FDATE.ATTRIBUTE2
, FDATE.ATTRIBUTE3
, FDATE.ATTRIBUTE4
, FDATE.ATTRIBUTE5
, FDATE.ATTRIBUTE6
, FDATE.ATTRIBUTE7
, FDATE.ATTRIBUTE8
, FDATE.ATTRIBUTE9
, FDATE.ATTRIBUTE10
, FDATE.ATTRIBUTE11
, FDATE.ATTRIBUTE12
, FDATE.ATTRIBUTE13
, FDATE.ATTRIBUTE14
, FDATE.ATTRIBUTE15
, FDATE.PROJECT_ID
, MRP_GET_PROJECT.PROJECT(FDATE.PROJECT_ID)
, FDATE.TASK_ID
, MRP_GET_PROJECT.TASK(FDATE.TASK_ID)
, WIP.LINE_ID
, WIP.LINE_CODE
, KFV.ITEM_NUMBER
FROM WIP_LINES WIP
, MTL_ITEM_FLEXFIELDS KFV
, MTL_PARAMETERS PARAM
, MFG_LOOKUPS L1
, MRP_FORECAST_DATES FDATE
WHERE FDATE.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND FDATE.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND FDATE.ORIGINATION_TYPE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'MRP_FORECAST_ORIG'
AND FDATE.SOURCE_ORGANIZATION_ID = PARAM.ORGANIZATION_ID(+)
AND FDATE.LINE_ID = WIP.LINE_ID(+)
AND FDATE.ORGANIZATION_ID = WIP.ORGANIZATION_ID(+)

Columns