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_SCE_LOADS_PKG dependencies on MSC_ITEM_SUPPLIERS

Line 1048: from msc_item_suppliers mis

1044: ln.supplier_item_name)) and
1045: msi.plan_id = -1
1046: UNION
1047: select mis.inventory_item_id
1048: from msc_item_suppliers mis
1049: where mis.supplier_item_name = NVL(ln.owner_item_name,
1050: NVL(ln.customer_item_name,
1051: ln.supplier_item_name)) and
1052: mis.plan_id = -1

Line 1950: from msc_item_suppliers mis,

1946: NVL(part.company_id,1) = c.company_id and
1947: ln.item_name IS NULL
1948: UNION
1949: select mis.inventory_item_id
1950: from msc_item_suppliers mis,
1951: msc_trading_partners mtp,
1952: msc_trading_partner_maps map,
1953: msc_trading_partner_maps map1,
1954: msc_trading_partner_maps map2,

Line 2491: from msc_item_suppliers mis,

2487: NVL(part.company_id,1) = c.company_id and
2488: ln.item_name IS NULL
2489: UNION
2490: select mis.inventory_item_id
2491: from msc_item_suppliers mis,
2492: msc_trading_partner_maps map,
2493: msc_trading_partner_maps map1,
2494: msc_company_relationships r,
2495: msc_company_sites cs,

Line 7770: from msc_item_suppliers mis,

7766: nvl(mis.uom_code,msi.uom_code),
7767: msi.base_item_id,
7768: itm.item_name,
7769: msi.planner_code
7770: from msc_item_suppliers mis,
7771: msc_system_items msi,
7772: msc_items itm,
7773: msc_items itm1,
7774: msc_trading_partner_maps map,

Line 7817: from msc_item_suppliers mis,

7813: ) IS
7814: select mis.supplier_item_name,
7815: nvl(mis.description,itm.description),
7816: mis.uom_code
7817: from msc_item_suppliers mis,
7818: msc_items itm,
7819: msc_trading_partner_maps map,
7820: msc_trading_partner_maps map1,
7821: msc_trading_partner_maps map2,

Line 7857: msc_item_suppliers mis

7853: mis.enable_vmi_auto_replenish_flag
7854: FROM msc_trading_partners mtp,
7855: msc_trading_partner_sites mtps,
7856: msc_trading_partners mtp1,
7857: msc_item_suppliers mis
7858: WHERE Upper(mtp.partner_name) = Upper(p_supplier)
7859: AND mtp.partner_type = 1
7860: AND mtps.partner_id = mtp.partner_id
7861: AND Upper(mtps.tp_site_code) = Upper(p_supplier_site)

Line 10046: FROM msc_item_suppliers mis,

10042: mssn.master_item_name IS NULL
10043:
10044: UNION ALL
10045: SELECT mis.inventory_item_id
10046: FROM msc_item_suppliers mis,
10047: msc_trading_partner_maps map,
10048: msc_trading_partner_maps map1,
10049: msc_company_relationships r,
10050: msc_company_sites cs,