APPS.MSC_X_NETTING3_PKG dependencies on MSC_COMPANY_RELATIONSHIPS

Line 518: msc_company_relationships r

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
522: AND map.company_key = sd1.publisher_site_id

Line 583: msc_company_relationships r

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
587: AND map.company_key = sd1.publisher_site_id

Line 647: msc_company_relationships r

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
651: AND map.company_key = sd1.publisher_site_id

Line 2721: msc_company_relationships rel,

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,
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

Line 3014: msc_company_relationships rel,

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,
3016: msc_sup_dem_entries sd,
3017: msc_sales_orders mso
3018: WHERE dem.demand_id = l_demand_id