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_ANALYSIS_PKG dependencies on MSC_SERVICE_LEVELS

Line 1709: from msc_service_levels

1705: l_dflt_level number;
1706:
1707: cursor c_dflt is
1708: select nvl(demand_fulfillment_lead_time,0)
1709: from msc_service_levels
1710: where plan_id = p_plan_id
1711: --and category_set_id = l_cate_set_id
1712: and definition_level = l_dflt_level
1713: and ( ( sr_instance_id is null and organization_id is null

Line 1729: from msc_service_levels

1725: or (sr_category_id = p_cate_id) );
1726:
1727: cursor c_dflt_with_level is
1728: select nvl(demand_fulfillment_lead_time,0)
1729: from msc_service_levels
1730: where plan_id = p_plan_id
1731: --and category_set_id = l_cate_set_id
1732: and definition_level = nvl(p_definition_level, definition_level)
1733: --and nvl(sr_instance_id, -1) = nvl(p_inst_id, -1) --not req as they populate for every row