DBA Data[Home] [Help]

APPS.MSC_GLOBAL_FORECASTING dependencies on MSC_FORECAST_UPDATES

Line 202: msc_forecast_updates forecast

198: forecast.consumption_date old_date,
199: sum(nvl(forecast.consumed_qty,0)) new_quantity,
200: 0 old_quantity
201: FROM msc_form_query list,
202: msc_forecast_updates forecast
203: where forecast.organization_id = list.number2
204: AND forecast.plan_id = list.number4
205: AND forecast.inventory_item_id = list.number1
206: AND forecast.sr_instance_id = list.number3

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

1128: IF p_rowtype = CONSUMED THEN -- Forecast Consumed Row
1129:
1130: sql_stmt := sql_stmt ||
1131: ' md.demand_id '||
1132: ' FROM msc_forecast_updates mfu, msc_demands md'||
1133: ' WHERE mfu.plan_id = :p_plan_id' ||
1134: ' AND mfu.sr_instance_id = :p_inst_id'||
1135: ' and mfu.organization_id =:p_org_id '||
1136: ' and mfu.inventory_item_id = :p_item_id' ||