VIEW: APPS.MRP_FORECAST_ITEMS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'