Script to check forecast Consumption

Hi All,

I'm looking for a script to check the forecast consumption accuracy against the sale orders.

Doubts:

1) In which table the 'consumed forecast' valued is stored?

2) Is it possible to find out which sale orders has been consumed against the forecast qty in particular bucket?

I've checked in msc_orders_v table, but I'm not able to find the column 'consumed forecast' and also noticed that: I'm getting multiple records for below scripts

select * from msc_orders_v

where TRANSACTION_ID=1259346112

and order_type=29

and order_type_text='Forecast'

and plan_id=1

and item_name='100882'

and organization_code='PRD:400';