APPS.MSC_SDA_PKG dependencies on MSC_SYSTEM_ITEMS

Line 741: from msc_system_items msi,

737: l_row_type number;
738: l_offset number;
739: cursor c_usage_based_fcst_cur is
740: select count(*)
741: from msc_system_items msi,
742: msc_forecast_rules mfr
743: where msi.plan_id = g_plan_id
744: and msi.sr_instance_id = p_inst_id
745: and msi.organization_id = p_org_id

Line 1767: msc_system_items msi

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
1770: and mfq1.query_id = g_org_query_id
1771: and nvl(mfq1.number1,c_mbp_null_value) = nvl(maq.org_list_id,c_mbp_null_value)

Line 1827: msc_system_items msi

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
1829: and maq.parent_row_index = g_next_rowset_index
1830: and mfq1.query_id = g_org_query_id
1831: and nvl(mfq1.number1,c_mbp_null_value) = nvl(maq.org_list_id,c_mbp_null_value)

Line 2452: msc_system_items msi,

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
2456: and mfq1.query_id = g_org_query_id

Line 2523: msc_system_items msi,

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
2527: and mfq1.query_id = g_org_query_id

Line 2592: msc_system_items msi,

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
2596: and mfq1.query_id = g_org_query_id