eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SDA_PKG dependencies on MSC_PLANS

Line 554: from msc_plans

550: sr_instance_id,
551: organization_id,
552: decode(plan_id, -1, sysdate, trunc(curr_start_date)) curr_start_date,
553: decode(plan_id, -1, sysdate+365, trunc(curr_cutoff_date)) curr_cutoff_date
554: from msc_plans
555: where plan_id = g_plan_id;
556:
557: cursor c_plan_bucket_info_cur is
558: select sum(decode(bucket_type, 1, 1,0)) day_buckets,

Line 580: from msc_plans

576: union all
577: select trunc(curr_start_date)-1,
578: trunc(curr_start_date)-1,
579: -99
580: from msc_plans
581: where plan_id = g_plan_id
582: union all
583: select trunc(curr_cutoff_date)+1,
584: trunc(curr_cutoff_date)+1,

Line 586: from msc_plans

582: union all
583: select trunc(curr_cutoff_date)+1,
584: trunc(curr_cutoff_date)+1,
585: -99
586: from msc_plans
587: where plan_id = g_plan_id
588: order by 1;
589:
590: cursor c_week_start_dates_cur(p_cal_type number, p_cal_code varchar2) is

Line 1494: msc_plans mp,

1490: from
1491: msc_demands md,
1492: msc_analysis_query maq,
1493: msc_form_query mfq2, -- item-list
1494: msc_plans mp,
1495: msc_form_query mfq3 --g_plan_bkts_query_id
1496: where maq.query_id = p_query_id
1497: and maq.region_id = c_global_reg_type
1498: and mfq2.query_id = g_chain_query_id

Line 1765: msc_plans mp,

1761: msc_supplies ms,
1762: msc_analysis_query maq,
1763: msc_form_query mfq1, -- org-list
1764: msc_form_query mfq2, -- item-list
1765: msc_plans mp,
1766: msc_form_query mfq3, --g_plan_bkts_query_id
1767: msc_system_items msi
1768: where maq.query_id = p_query_id
1769: and maq.parent_row_index = g_next_rowset_index

Line 1824: msc_plans mp,

1820: msc_demands md,
1821: msc_analysis_query maq,
1822: msc_form_query mfq1, -- org-list
1823: msc_form_query mfq2, -- item-list
1824: msc_plans mp,
1825: msc_form_query mfq3, --g_plan_bkts_query_id
1826: msc_instance_orgs mio,
1827: msc_system_items msi
1828: where maq.query_id = p_query_id

Line 2046: msc_plans mp,

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

Line 2125: msc_plans mp,

2121: msc_demands md,
2122: msc_analysis_query maq,
2123: msc_form_query mfq1, -- region-to-org-list
2124: msc_form_query mfq2, -- item-list
2125: msc_plans mp,
2126: msc_form_query mfq3 --g_plan_bkts_query_id
2127: where maq.query_id = p_query_id
2128: and maq.parent_row_index = g_next_rowset_index
2129: and mfq1.query_id = g_org_query_id

Line 2203: msc_plans mp,

2199: msc_analysis_query maq,
2200: msc_form_query mfq1, -- region-to-org-list
2201: msc_form_query mfq2, -- item-list
2202: msc_form_query mfq4, -- msc_demands duplicate rows
2203: msc_plans mp,
2204: msc_form_query mfq3 --g_plan_bkts_query_id
2205: where maq.query_id = p_query_id
2206: and maq.parent_row_index = g_next_rowset_index
2207: and mfq1.query_id = g_org_query_id

Line 2265: msc_plans mp,

2261: msc_demands md,
2262: msc_analysis_query maq,
2263: msc_form_query mfq1, -- region-to-org-list
2264: msc_form_query mfq2, -- item-list
2265: msc_plans mp,
2266: msc_forecast_updates mfu,
2267: msc_form_query mfq3 --g_plan_bkts_query_id
2268: where maq.query_id = p_query_id
2269: and maq.parent_row_index = g_next_rowset_index

Line 2325: msc_plans mp,

2321: msc_demands md,
2322: msc_analysis_query maq,
2323: msc_form_query mfq1, -- region-to-org-list
2324: msc_form_query mfq2, -- item-list
2325: msc_plans mp,
2326: msc_forecast_updates mfu,
2327: msc_form_query mfq3 --g_plan_bkts_query_id
2328: where maq.query_id = p_query_id
2329: and maq.parent_row_index = g_next_rowset_index

Line 2382: msc_plans mp,

2378: msc_demands md,
2379: msc_analysis_query maq,
2380: msc_form_query mfq1, -- region-to-org-list
2381: msc_form_query mfq2, -- item-list
2382: msc_plans mp,
2383: msc_forecast_updates mfu,
2384: msc_form_query mfq3 --g_plan_bkts_query_id
2385: where maq.query_id = p_query_id
2386: and maq.parent_row_index = g_next_rowset_index

Line 2451: msc_plans mp,

2447: msc_supplies ms,
2448: msc_analysis_query maq,
2449: msc_form_query mfq1, -- region-to-org-list
2450: msc_form_query mfq2, -- item-list
2451: msc_plans mp,
2452: msc_system_items msi,
2453: msc_form_query mfq3 --g_plan_bkts_query_id
2454: where maq.query_id = p_query_id
2455: and maq.parent_row_index = g_next_rowset_index

Line 2522: msc_plans mp,

2518: msc_supplies ms,
2519: msc_analysis_query maq,
2520: msc_form_query mfq1, -- region-to-org-list
2521: msc_form_query mfq2, -- item-list
2522: msc_plans mp,
2523: msc_system_items msi,
2524: msc_form_query mfq3 --g_plan_bkts_query_id
2525: where maq.query_id = p_query_id
2526: and maq.parent_row_index = g_next_rowset_index

Line 2591: msc_plans mp,

2587: msc_analysis_query maq,
2588: msc_form_query mfq1, -- region-to-org-list
2589: msc_form_query mfq2, -- item-list
2590: msc_form_query mfq4, -- msc_supplies duplicate rows
2591: msc_plans mp,
2592: msc_system_items msi,
2593: msc_form_query mfq3 --g_plan_bkts_query_id
2594: where maq.query_id = p_query_id
2595: and maq.parent_row_index = g_next_rowset_index