APPS.MSC_SDA_PKG dependencies on MSC_SYSTEM_ITEMS

Line 729: from msc_system_items msi,

725: l_row_type number;
726: l_offset number;
727: cursor c_usage_based_fcst_cur is
728: select count(*)
729: from msc_system_items msi,
730: msc_forecast_rules mfr
731: where msi.plan_id = g_plan_id
732: and msi.sr_instance_id = p_inst_id
733: and msi.organization_id = p_org_id

Line 1555: msc_system_items msi

1551: msc_form_query mfq1, -- org-list
1552: msc_form_query mfq2, -- item-list
1553: msc_plans mp,
1554: msc_form_query mfq3, --g_plan_bkts_query_id
1555: msc_system_items msi
1556: where maq.query_id = p_query_id
1557: and maq.parent_row_index = g_next_rowset_index
1558: and mfq1.query_id = g_org_query_id
1559: and nvl(mfq1.number1,c_mbp_null_value) = nvl(maq.org_list_id,c_mbp_null_value)

Line 1615: msc_system_items msi

1611: msc_form_query mfq2, -- item-list
1612: msc_plans mp,
1613: msc_form_query mfq3, --g_plan_bkts_query_id
1614: msc_instance_orgs mio,
1615: msc_system_items msi
1616: where maq.query_id = p_query_id
1617: and maq.parent_row_index = g_next_rowset_index
1618: and mfq1.query_id = g_org_query_id
1619: and nvl(mfq1.number1,c_mbp_null_value) = nvl(maq.org_list_id,c_mbp_null_value)

Line 2230: msc_system_items msi

2226: msc_form_query mfq1, -- region-to-org-list
2227: msc_form_query mfq2, -- item-list
2228: msc_plans mp,
2229: msc_form_query mfq3, --g_plan_bkts_query_id
2230: msc_system_items msi
2231: where maq.query_id = p_query_id
2232: and maq.parent_row_index = g_next_rowset_index
2233: and mfq1.query_id = g_org_query_id
2234: and mfq1.number1 = nvl(maq.region_id, mfq1.number1)