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_SNO_PKG dependencies on MSC_SYSTEM_ITEMS

Line 180: msc_system_items msi,

176: msc_plans mp
177: where mp.plan_id = med.plan_id
178: and mp.plan_type = 6
179: and mp.plan_id = p_plan_id) t,
180: msc_system_items msi,
181: msc_trading_partners mtp
182: where msi.plan_id(+) = t.plan_id
183: and msi.inventory_item_id(+) = t.inventory_item_id
184: and msi.organization_id(+) = t.eff_organization_id

Line 455: msc_system_items msi,

451: to_number(null) buy_order_value2, -- wei: temp, should use lines above
452: to_number(null) buy_order_count -- wei: temp, should use lines above
453: from
454: msc_supplies ms,
455: msc_system_items msi,
456: msc_plans mp,
457: msc_trading_partners mtp
458: where mp.plan_id = p_plan_id
459: and mp.plan_type = 6

Line 587: msc_system_items msi,

583: nvl(md.customer_site_id, -23453),
584: nvl(md.demand_class, '-23453'),
585: trunc(nvl(md.firm_date, md.using_assembly_demand_date)),
586: md.origination_type) t1,
587: msc_system_items msi,
588: msc_plans mp,
589: msc_currency_conv_mv mcc
590: where msi.plan_id = t1.plan_id
591: and msi.sr_instance_id = decode(sign(t1.sr_instance_id), -1, mp.sr_instance_id, t1.sr_instance_id) --wei