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_RECEIVE_CAPACITY_PKG dependencies on MSC_TRADING_PARTNER_MAPS

Line 43: msc_trading_partner_maps map1,

39: map2.tp_key, -- supplier_aps_id
40: map3.tp_key, -- supplier_site aps id
41: item1.ROUNDING_CONTROL_TYPE
42: FROM msc_sup_dem_entries_v sd,
43: msc_trading_partner_maps map1,
44: msc_trading_partners tp,
45: msc_system_items item,
46: msc_company_relationships cr,
47: msc_trading_partner_maps map2,

Line 47: msc_trading_partner_maps map2,

43: msc_trading_partner_maps map1,
44: msc_trading_partners tp,
45: msc_system_items item,
46: msc_company_relationships cr,
47: msc_trading_partner_maps map2,
48: msc_trading_partner_maps map3,
49: msc_item_suppliers mis,
50: msc_trading_partners tp2,
51: msc_system_items item1

Line 48: msc_trading_partner_maps map3,

44: msc_trading_partners tp,
45: msc_system_items item,
46: msc_company_relationships cr,
47: msc_trading_partner_maps map2,
48: msc_trading_partner_maps map3,
49: msc_item_suppliers mis,
50: msc_trading_partners tp2,
51: msc_system_items item1
52: WHERE sd.plan_id = -1

Line 119: msc_trading_partner_maps map1,

115: map2.tp_key,
116: map3.tp_key,
117: item1.ROUNDING_CONTROL_TYPE
118: FROM msc_sup_dem_entries_v sd,
119: msc_trading_partner_maps map1,
120: msc_trading_partners tp,
121: msc_system_items item,
122: MSC_CAL_WEEK_START_DATES mcd,
123: msc_company_relationships cr,

Line 124: msc_trading_partner_maps map2,

120: msc_trading_partners tp,
121: msc_system_items item,
122: MSC_CAL_WEEK_START_DATES mcd,
123: msc_company_relationships cr,
124: msc_trading_partner_maps map2,
125: msc_trading_partner_maps map3,
126: msc_item_suppliers mis,
127: msc_trading_partners tp2,
128: msc_system_items item1

Line 125: msc_trading_partner_maps map3,

121: msc_system_items item,
122: MSC_CAL_WEEK_START_DATES mcd,
123: msc_company_relationships cr,
124: msc_trading_partner_maps map2,
125: msc_trading_partner_maps map3,
126: msc_item_suppliers mis,
127: msc_trading_partners tp2,
128: msc_system_items item1
129: WHERE sd.plan_id = -1

Line 203: msc_trading_partner_maps map1,

199: map2.tp_key,
200: map3.tp_key,
201: item1.ROUNDING_CONTROL_TYPE
202: FROM msc_sup_dem_entries_v sd,
203: msc_trading_partner_maps map1,
204: msc_trading_partners tp,
205: msc_system_items item,
206: MSC_PERIOD_START_DATES mpd,
207: msc_company_relationships cr,

Line 208: msc_trading_partner_maps map2,

204: msc_trading_partners tp,
205: msc_system_items item,
206: MSC_PERIOD_START_DATES mpd,
207: msc_company_relationships cr,
208: msc_trading_partner_maps map2,
209: msc_trading_partner_maps map3,
210: msc_item_suppliers mis,
211: msc_trading_partners tp2,
212: msc_system_items item1

Line 209: msc_trading_partner_maps map3,

205: msc_system_items item,
206: MSC_PERIOD_START_DATES mpd,
207: msc_company_relationships cr,
208: msc_trading_partner_maps map2,
209: msc_trading_partner_maps map3,
210: msc_item_suppliers mis,
211: msc_trading_partners tp2,
212: msc_system_items item1
213: WHERE sd.plan_id = -1

Line 274: msc_trading_partner_maps map1,

270: p_sce_supplier_site_id IN NUMBER,
271: p_bucket_type IN NUMBER) IS
272: SELECT sum(sd.tp_quantity)
273: FROM msc_sup_dem_entries_v sd,
274: msc_trading_partner_maps map1,
275: msc_trading_partners tp,
276: msc_system_items item
277: WHERE sd.plan_id = -1
278: AND sd.publisher_order_type = SUPPLY_COMMIT

Line 458: FROM msc_trading_partner_maps map1,

454: --LOG_MESSAGE('Start map the supplier_id');
455: BEGIN
456: SELECT distinct c.company_id
457: INTO l_map_supplier_id
458: FROM msc_trading_partner_maps map1,
459: msc_company_relationships rel,
460: msc_companies c,
461: msc_trading_partners tp
462: WHERE rel.relationship_type =2 AND --supplier

Line 487: FROM msc_trading_partner_maps map1,

483: --LOG_MESSAGE('Start map the supplier_site_id');
484: BEGIN
485: SELECT distinct s.company_site_id
486: INTO l_map_supplier_site_id
487: FROM msc_trading_partner_maps map1,
488: msc_companies c,
489: msc_company_sites s,
490: msc_trading_partners tp,
491: msc_trading_partner_sites tps

Line 652: FROM msc_trading_partner_maps map1,

648: IF (p_supplier_id is null ) THEN
649: begin
650: SELECT distinct tp.partner_id
651: INTO l_aps_supplier_id
652: FROM msc_trading_partner_maps map1,
653: msc_company_relationships rel,
654: msc_item_suppliers sup,
655: msc_trading_partners tp
656: WHERE rel.relationship_type =2 AND --supplier

Line 684: FROM msc_trading_partner_maps map1,

680: IF (p_supplier_site_id is null) THEN
681: begin
682: SELECT distinct tps.partner_site_id
683: INTO l_aps_supplier_site_id
684: FROM msc_trading_partner_maps map1,
685: msc_companies c,
686: msc_company_sites s,
687: msc_trading_partners tp,
688: msc_trading_partner_sites tps

Line 715: FROM msc_trading_partner_maps map1,

711: IF (p_supplier_id is null ) THEN
712: BEGIN
713: SELECT distinct c.company_id
714: INTO l_map_supplier_id
715: FROM msc_trading_partner_maps map1,
716: msc_company_relationships rel,
717: msc_companies c,
718: msc_trading_partners tp
719: WHERE rel.relationship_type =2 AND --supplier

Line 742: FROM msc_trading_partner_maps map1,

738: IF (p_supplier_site_id is null ) THEN
739: Begin
740: SELECT distinct s.company_site_id
741: INTO l_map_supplier_site_id
742: FROM msc_trading_partner_maps map1,
743: msc_companies c,
744: msc_company_sites s,
745: msc_trading_partners tp,
746: msc_trading_partner_sites tps