Forecast Details

SELECT
  msib.segment1 item
,msib.description
,msib.primary_unit_of_measure uom
(select organization_code from org_organization_definitions where organization_id=msib.organization_id) organization_code
, mfi.forecast_designator
, mfd.forecast_set
, mfd.bucket_type
, mf.forecast_date
, mf.original_forecast_quantity
, mf.current_forecast_quantity
,mf.confidence_percentage
,mf.origination_type
,mf.comments
FROM
  MRP_FORECAST_ITEMS mfi
, mtl_system_items_b msib
,MRP_FORECAST_DESIGNATORS_V mfd
, MRP_FORECAST_DATES mf
WHERE
  msib.inventory_item_id   =mfi.inventory_item_id
AND msib.organization_id   =mfi.organization_id
AND mfd.forecast_designator= mfi.forecast_designator
AND mfd.organization_id    =mfi.organization_id
and mf.inventory_item_id=msib.inventory_item_id
and mf.organization_id=msib.organization_id
and mf.forecast_designator=mfd.forecast_designator
AND mfi.forecast_designator=:P_FORECAST_DESIGNATOR
and msib.organization_id=:P_ORG_ID
and mfd.forecast_set=:P_FORECAST_SET;