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_X_NETTING3_PKG dependencies on MSC_TRADING_PARTNERS

Line 448: msc_trading_partners t,

444: SELECT SUP.TRANSACTION_ID -- the 1st level of po transaction id in ASCP
445: FROM msc_supplies sup,
446: msc_companies c,
447: msc_company_sites s,
448: msc_trading_partners t,
449: msc_trading_partner_maps m
450: WHERE sup.plan_id = P_PLAN_ID
451: AND decode(instr(sup.order_number,'('),0, sup.order_number,substr(sup.order_number, 1, instr(sup.order_number,'(') - 1)) = P_ORDER_NUMBER
452: AND sup.purch_line_num = P_LINE_NUMBER

Line 513: msc_trading_partners tp,

509: sd1.inventory_item_id,
510: sd1.supplier_id,
511: sd1.supplier_site_id
512: FROM msc_sup_dem_entries sd1,
513: msc_trading_partners tp,
514: msc_trading_partner_maps map,
515: msc_item_suppliers itm,
516: msc_trading_partner_maps map2,
517: msc_trading_partner_maps map3,

Line 578: msc_trading_partners tp,

574: sd1.supplier_item_description,
575: sd1.creation_date,
576: nvl(itm.processing_lead_time,0)
577: FROM msc_sup_dem_entries sd1,
578: msc_trading_partners tp,
579: msc_trading_partner_maps map,
580: msc_item_suppliers itm,
581: msc_trading_partner_maps map2,
582: msc_trading_partner_maps map3,

Line 642: msc_trading_partners tp,

638: sd1.supplier_item_description,
639: sd1.creation_date,
640: nvl(itm.processing_lead_time,0)
641: FROM msc_sup_dem_entries sd1,
642: msc_trading_partners tp,
643: msc_trading_partner_maps map,
644: msc_item_suppliers itm,
645: msc_trading_partner_maps map2,
646: msc_trading_partner_maps map3,

Line 2715: msc_trading_partners t1,

2711: l_customer_item_desc
2712: FROM msc_supplies sup,
2713: msc_companies c1,
2714: msc_company_sites s1,
2715: msc_trading_partners t1,
2716: msc_trading_partner_maps m1,
2717: msc_trading_partners t2,
2718: msc_trading_partner_maps m2,
2719: msc_companies c2,

Line 2717: msc_trading_partners t2,

2713: msc_companies c1,
2714: msc_company_sites s1,
2715: msc_trading_partners t1,
2716: msc_trading_partner_maps m1,
2717: msc_trading_partners t2,
2718: msc_trading_partner_maps m2,
2719: msc_companies c2,
2720: msc_company_sites s2,
2721: msc_company_relationships rel,

Line 3008: msc_trading_partners t1,

3004: l_customer_item_desc
3005: FROM msc_demands dem,
3006: msc_companies c1,
3007: msc_company_sites s1,
3008: msc_trading_partners t1,
3009: msc_trading_partner_maps m1,
3010: msc_trading_partners t2,
3011: msc_trading_partner_maps m2,
3012: msc_companies c2,

Line 3010: msc_trading_partners t2,

3006: msc_companies c1,
3007: msc_company_sites s1,
3008: msc_trading_partners t1,
3009: msc_trading_partner_maps m1,
3010: msc_trading_partners t2,
3011: msc_trading_partner_maps m2,
3012: msc_companies c2,
3013: msc_company_sites s2,
3014: msc_company_relationships rel,