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_SAFETY_STOCK dependencies on MSC_GET_BIS_VALUES

Line 476: msc_get_bis_values.service_target(plan_id,instance_id,org_id,item_id))) AS target_sl

472: plan_name,
473: org_name,
474: item_name,
475: avg(nvl(get_customer_target_sl(partner_id) ,
476: msc_get_bis_values.service_target(plan_id,instance_id,org_id,item_id))) AS target_sl
477: FROM
478: (
479: SELECT DISTINCT msi.plan_id AS plan_id, msi.sr_instance_id AS instance_id, msi.organization_id AS org_id,
480: msi.inventory_item_id AS item_id,

Line 528: msc_get_bis_values.service_target(plan_id,instance_id,org_id,item_id))) AS target_sl

524: -- view by customer service levels
525: CURSOR c2 IS
526: SELECT plan_id, nvl(partner_id, UNDEFINED_CUSTOMER_ID), partner_name, nvl(customer_class_code, UNDEFINED_CUSTOMER_CODE),
527: avg(nvl(get_customer_target_sl(partner_id) ,
528: msc_get_bis_values.service_target(plan_id,instance_id,org_id,item_id))) AS target_sl
529: FROM
530: (SELECT DISTINCT msi.plan_id AS plan_id, msi.sr_instance_id AS instance_id, msi.organization_id AS org_id,
531: msi.inventory_item_id AS item_id,
532: mic.sr_category_id AS sr_category_id, mic.category_name AS category_name,