View: MRP_FORECAST_ITEMS_V

Product:	MRP - Master Scheduling/MRP
Description:	Forecast items view
Implementation/DBA Data:	APPS.MRP_FORECAST_ITEMS_V

View Text

SELECT MFI.ROWID ROW_ID
, MFI.INVENTORY_ITEM_ID
, KFV.CONCATENATED_SEGMENTS
, KFV.DESCRIPTION ITEM_DESCRIPTION
, KFV.PRIMARY_UOM_CODE
, KFV.BOM_ITEM_TYPE
, KFV.PICK_COMPONENTS_FLAG
, L1.MEANING BOM_ITEM_TYPE_DESC
, L2.MEANING ATO_FORECAST_CONTROL_DESC
, L3.MEANING MRP_PLANNING_CODE_DESC
, MFI.ALTERNATE_BOM_DESIGNATOR
, MFI.ORGANIZATION_ID
, MFI.FORECAST_DESIGNATOR
, MFI.LAST_UPDATE_DATE
, MFI.LAST_UPDATED_BY
, MFI.CREATION_DATE
, MFI.CREATED_BY
, MFI.LAST_UPDATE_LOGIN
, MFI.REQUEST_ID
, MFI.PROGRAM_APPLICATION_ID
, MFI.PROGRAM_ID
, MFI.PROGRAM_UPDATE_DATE
, MFI.ATTRIBUTE_CATEGORY
, MFI.ATTRIBUTE1
, MFI.ATTRIBUTE2
, MFI.ATTRIBUTE3
, MFI.ATTRIBUTE4
, MFI.ATTRIBUTE5
, MFI.ATTRIBUTE6
, MFI.ATTRIBUTE7
, MFI.ATTRIBUTE8
, MFI.ATTRIBUTE9
, MFI.ATTRIBUTE10
, MFI.ATTRIBUTE11
, MFI.ATTRIBUTE12
, MFI.ATTRIBUTE13
, MFI.ATTRIBUTE14
, MFI.ATTRIBUTE15
FROM MFG_LOOKUPS L3
, MFG_LOOKUPS L2
, MFG_LOOKUPS L1
, MTL_SYSTEM_ITEMS_VL KFV
, MRP_FORECAST_ITEMS MFI
WHERE MFI.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND MFI.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND L1.LOOKUP_CODE = KFV.BOM_ITEM_TYPE
AND L1.LOOKUP_TYPE = 'BOM_ITEM_TYPE'
AND L2.LOOKUP_CODE(+) = KFV.ATO_FORECAST_CONTROL
AND L2.LOOKUP_TYPE(+) = 'MRP_ATO_FORECAST_CONTROL'
AND L3.LOOKUP_CODE = KFV.MRP_PLANNING_CODE
AND L3.LOOKUP_TYPE = 'MRP_PLANNING_CODE'

Columns