APPS.MSC_SDA_PKG dependencies on MSC_FORECAST_UPDATES

Line 377: -- msc_forecast_updates.consumed_qty //pabram..need to check

373: -- nvl(manual forecast, net forecast + demand schedule)
374: c_row2_orig_fcst constant integer:= 2;
375: -- msc_demands --old_using_requirement_quantity, old_demand_quantity, original_quantity //pabram..need to check
376: c_row2_consumed_fcst constant integer:= 3;
377: -- msc_forecast_updates.consumed_qty //pabram..need to check
378: c_row2_net_fcst constant integer:= 4;
379: -- msc_demands origination_type 29 //pabram..need to check
380: c_row2_over_consmptn constant integer:= 5;
381: -- msc_forecast_updates.overconsumption_qty //pabram..need to check

Line 381: -- msc_forecast_updates.overconsumption_qty //pabram..need to check

377: -- msc_forecast_updates.consumed_qty //pabram..need to check
378: c_row2_net_fcst constant integer:= 4;
379: -- msc_demands origination_type 29 //pabram..need to check
380: c_row2_over_consmptn constant integer:= 5;
381: -- msc_forecast_updates.overconsumption_qty //pabram..need to check
382: c_row2_manual_fcst constant integer:= 6;
383: -- msc_demands origination_type 63 //pabram..need to check
384: c_row2_dmd_schd constant integer:= 7;
385: -- msc_demands origination_type 64 //pabram..need to check

Line 2044: msc_forecast_updates mfu,

2040: msc_analysis_query maq,
2041: msc_form_query mfq1, -- region-to-org-list
2042: msc_form_query mfq2, -- item-list
2043: msc_plans mp,
2044: msc_forecast_updates mfu,
2045: msc_form_query mfq3 --g_plan_bkts_query_id
2046: where maq.query_id = p_query_id
2047: and maq.parent_row_index = g_next_rowset_index
2048: and mfq1.query_id = g_org_query_id

Line 2103: msc_forecast_updates mfu,

2099: msc_analysis_query maq,
2100: msc_form_query mfq1, -- region-to-org-list
2101: msc_form_query mfq2, -- item-list
2102: msc_plans mp,
2103: msc_forecast_updates mfu,
2104: msc_form_query mfq3 --g_plan_bkts_query_id
2105: where maq.query_id = p_query_id
2106: and maq.parent_row_index = g_next_rowset_index
2107: and mfq1.query_id = g_org_query_id

Line 2160: msc_forecast_updates mfu,

2156: msc_analysis_query maq,
2157: msc_form_query mfq1, -- region-to-org-list
2158: msc_form_query mfq2, -- item-list
2159: msc_plans mp,
2160: msc_forecast_updates mfu,
2161: msc_form_query mfq3 --g_plan_bkts_query_id
2162: where maq.query_id = p_query_id
2163: and maq.parent_row_index = g_next_rowset_index
2164: and mfq1.query_id = g_org_query_id

Line 3371: p_from_table := 'msc_forecast_updates';

3367: elsif (p_row_offset = c_row2_orig_fcst) then
3368: p_from_table := 'msc_demands';
3369: p_order_type_list := c_dmd2_net_fcst;
3370: elsif (p_row_offset = c_row2_consumed_fcst) then
3371: p_from_table := 'msc_forecast_updates';
3372: p_order_type_list := null;
3373: elsif (p_row_offset = c_row2_net_fcst) then
3374: p_from_table := 'msc_demands';
3375: p_order_type_list := c_dmd2_net_fcst;

Line 3377: p_from_table := 'msc_forecast_updates';

3373: elsif (p_row_offset = c_row2_net_fcst) then
3374: p_from_table := 'msc_demands';
3375: p_order_type_list := c_dmd2_net_fcst;
3376: elsif (p_row_offset = c_row2_over_consmptn) then
3377: p_from_table := 'msc_forecast_updates';
3378: p_order_type_list := null;
3379: elsif (p_row_offset = c_row2_manual_fcst) then
3380: p_from_table := 'msc_demands';
3381: p_order_type_list := c_dmd2_manual_fcst;

Line 3637: if (p_from_table = 'msc_forecast_updates') then

3633: if (l_part_condition is null) then
3634: l_part_condition := c_part_good;
3635: end if;
3636:
3637: if (p_from_table = 'msc_forecast_updates') then
3638: return;
3639: end if;
3640:
3641: p_mfq_id := msc_sda_utils.getNewFormQueryId;

Line 3648: elsif (p_from_table in ('msc_demands', 'msc_forecast_updates') ) then

3644: ' select distinct '|| p_mfq_id ||', sysdate, 1, sysdate, 1, ';
3645:
3646: if (p_from_table = 'msc_supplies') then
3647: sql_stmt := sql_stmt || ' transaction_id from '|| p_from_table;
3648: elsif (p_from_table in ('msc_demands', 'msc_forecast_updates') ) then
3649: sql_stmt := sql_stmt || ' demand_id from '|| p_from_table;
3650: elsif (p_from_table = 'msc_orders_v') then
3651: sql_stmt := sql_stmt || ' transaction_id from '|| p_from_table;
3652: end if;

Line 3677: elsif (p_from_table in ('msc_demands', 'msc_forecast_updates') ) then

3673: ||' and nvl(item_type_value, '|| c_part_good ||' )= '|| l_part_condition ;
3674:
3675: msc_sda_utils.println('msc_supplies '||sql_stmt);
3676: execute immediate sql_stmt using l_date1, l_date2;
3677: elsif (p_from_table in ('msc_demands', 'msc_forecast_updates') ) then
3678: sql_stmt := sql_stmt || ' and origination_type in ('|| l_order_type_list ||')';
3679: sql_stmt := sql_stmt || ' and trunc(using_assembly_demand_date) between trunc(:l_date1) and trunc(:l_date2) ';
3680: sql_stmt := sql_stmt || ' and nvl(item_type_id, '||c_part_cond_id ||')= '|| c_part_cond_id
3681: ||' and nvl(item_type_value, '|| c_part_good ||' )= '|| l_part_condition ;

Line 3693: msc_sda_utils.println('msc_demands, msc_forecast_updates '||sql_stmt);

3689: sql_stmt := sql_stmt || ' and disposition_id is not null ';
3690: end if;
3691: end if;
3692:
3693: msc_sda_utils.println('msc_demands, msc_forecast_updates '||sql_stmt);
3694: execute immediate sql_stmt using l_date1, l_date2;
3695: elsif (p_from_table = 'msc_orders_v') then
3696: sql_stmt := sql_stmt || ' and nvl(item_type_id, '||c_part_cond_id ||')= '|| c_part_cond_id
3697: ||' and nvl(item_type_value, '|| c_part_good ||' )= '|| l_part_condition ;