VIEW: APPS.MRPFV_FORECAST_ITEMS

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE , AL.NAME , FO.FORECAST_DESIGNATOR , '_KF:INV:MSTK:SY' , SY.DESCRIPTION , SY.PRIMARY_UOM_CODE , FO.ALTERNATE_BOM_DESIGNATOR , '_LA:sy.bom_item_type:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING' , '_LA:sy.ato_forecast_control:MFG_LOOKUPS:MRP_ATO_FORECAST_CONTROL:MEANING' ,'_LA:sy.mrp_planning_code:MFG_LOOKUPS:MRP_PLANNING_CODE:MEANING' , '_DF:MRP:MRP_FORECAST_ITEMS:fo' , FO.ORGANIZATION_ID , FO.INVENTORY_ITEM_ID , FO.LAST_UPDATE_DATE , FO.LAST_UPDATED_BY , FO.CREATION_DATE , FO.CREATED_BY FROM MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,MTL_SYSTEM_ITEMS SY ,MRP_FORECAST_ITEMS FO WHERE FO.ORGANIZATION_ID = SY.ORGANIZATION_ID AND FO.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID AND FO.ORGANIZATION_ID = PA.ORGANIZATION_ID AND FO.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:FO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, FO.FORECAST_DESIGNATOR
, '_KF:INV:MSTK:SY'
, SY.DESCRIPTION
, SY.PRIMARY_UOM_CODE
, FO.ALTERNATE_BOM_DESIGNATOR
, '_LA:SY.BOM_ITEM_TYPE:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING'
, '_LA:SY.ATO_FORECAST_CONTROL:MFG_LOOKUPS:MRP_ATO_FORECAST_CONTROL:MEANING'
, '_LA:SY.MRP_PLANNING_CODE:MFG_LOOKUPS:MRP_PLANNING_CODE:MEANING'
, '_DF:MRP:MRP_FORECAST_ITEMS:FO'
, FO.ORGANIZATION_ID
, FO.INVENTORY_ITEM_ID
, FO.LAST_UPDATE_DATE
, FO.LAST_UPDATED_BY
, FO.CREATION_DATE
, FO.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MRP_FORECAST_ITEMS FO
WHERE FO.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND FO.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND FO.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND FO.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:FO.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY