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_SYSTEM_ITEMS

Line 1352: msc_system_items msi,

1348: */
1349: cursor c_tp_cost_new (p_plan_id in number, l_otype1 in number, l_otype2 in number, l_otype3 in number) is
1350: select round(sum(nvl(((ms.new_order_quantity * msi.unit_weight) * mism.cost_per_weight_unit),0)),6)
1351: from msc_supplies ms,
1352: msc_system_items msi,
1353: msc_interorg_ship_methods mism,
1354: msc_plans mp
1355: WHERE ms.plan_id = p_plan_id
1356: and ms.organization_id <> ms.source_organization_id

Line 1600: ' msc_system_items msi, '||

1596:
1597: sql_stat := ' select round(sum(nvl(((ms.new_order_quantity * '||
1598: ' msi.unit_weight) * mism.cost_per_weight_unit),0)),6), 0'||
1599: ' from msc_supplies ms, '||
1600: ' msc_system_items msi, '||
1601: ' msc_interorg_ship_methods mism '||
1602: ' WHERE ms.plan_id = :1 ' ||
1603: ' and ms.organization_id != ms.source_organization_id '||
1604: ' and ms.order_type in (' || l_order_type || ') '||