DBA Data[Home] [Help]

APPS.MSC_GLOBAL_FORECASTING dependencies on MSC_FORECAST_UPDATES

Line 197: msc_forecast_updates forecast

193: forecast.consumption_date old_date,
194: sum(nvl(forecast.consumed_qty,0)) new_quantity,
195: 0 old_quantity
196: FROM msc_form_query list,
197: msc_forecast_updates forecast
198: where forecast.organization_id = list.number2
199: AND forecast.plan_id = list.number4
200: AND forecast.inventory_item_id = list.number1
201: AND forecast.sr_instance_id = list.number3

Line 1124: ' FROM msc_forecast_updates mfu, msc_demands md'||

1120: IF p_rowtype = CONSUMED THEN -- Forecast Consumed Row
1121:
1122: sql_stmt := sql_stmt ||
1123: ' md.demand_id '||
1124: ' FROM msc_forecast_updates mfu, msc_demands md'||
1125: ' WHERE mfu.plan_id = :p_plan_id' ||
1126: ' AND mfu.sr_instance_id = :p_inst_id'||
1127: ' and mfu.organization_id =:p_org_id '||
1128: ' and mfu.inventory_item_id = :p_item_id' ||