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_PARTNER_MAPS

Line 449: msc_trading_partner_maps m

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
453: AND sup.inventory_item_id = P_ITEM_ID

Line 514: msc_trading_partner_maps map,

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,
518: msc_company_relationships r

Line 516: msc_trading_partner_maps map2,

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,
518: msc_company_relationships r
519: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
520: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --

Line 517: msc_trading_partner_maps map3,

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,
518: msc_company_relationships r
519: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
520: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
521: AND map.map_type = 2

Line 579: msc_trading_partner_maps map,

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,
583: msc_company_relationships r

Line 581: msc_trading_partner_maps map2,

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,
583: msc_company_relationships r
584: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
585: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --

Line 582: msc_trading_partner_maps map3,

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,
583: msc_company_relationships r
584: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
585: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
586: AND map.map_type = 2

Line 643: msc_trading_partner_maps map,

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,
647: msc_company_relationships r

Line 645: msc_trading_partner_maps map2,

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,
647: msc_company_relationships r
648: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
649: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --

Line 646: msc_trading_partner_maps map3,

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,
647: msc_company_relationships r
648: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
649: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
650: AND map.map_type = 2

Line 2716: msc_trading_partner_maps m1,

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,
2720: msc_company_sites s2,

Line 2718: msc_trading_partner_maps m2,

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,
2722: msc_trading_partner_maps m3,

Line 2722: msc_trading_partner_maps m3,

2718: msc_trading_partner_maps m2,
2719: msc_companies c2,
2720: msc_company_sites s2,
2721: msc_company_relationships rel,
2722: msc_trading_partner_maps m3,
2723: msc_sup_dem_entries sd
2724: WHERE sup.transaction_id = l_peg_trx_id
2725: AND sup.plan_id = l_plan_order_at_risk_id
2726: AND sup.sr_instance_id = l_peg_sr_instance_id

Line 3009: msc_trading_partner_maps m1,

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,
3013: msc_company_sites s2,

Line 3011: msc_trading_partner_maps m2,

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,
3015: msc_trading_partner_maps m3,

Line 3015: msc_trading_partner_maps m3,

3011: msc_trading_partner_maps m2,
3012: msc_companies c2,
3013: msc_company_sites s2,
3014: msc_company_relationships rel,
3015: msc_trading_partner_maps m3,
3016: msc_sup_dem_entries sd,
3017: msc_sales_orders mso
3018: WHERE dem.demand_id = l_demand_id
3019: AND dem.plan_id = l_plan_order_at_risk_id