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

Line 118: msc_trading_partner_maps map,

114: its.supplier_site_id
115: FROM msc_sup_dem_entries sd1,
116: msc_item_suppliers its,
117: msc_trading_partners tp,
118: msc_trading_partner_maps map,
119: msc_trading_partner_maps map2,
120: msc_trading_partner_maps map3,
121: msc_company_relationships r
122: WHERE sd1.plan_id = -1

Line 119: msc_trading_partner_maps map2,

115: FROM msc_sup_dem_entries sd1,
116: msc_item_suppliers its,
117: msc_trading_partners tp,
118: msc_trading_partner_maps map,
119: msc_trading_partner_maps map2,
120: msc_trading_partner_maps map3,
121: msc_company_relationships r
122: WHERE sd1.plan_id = -1
123: -- Alloc onhand, po, asn, recpt, req

Line 120: msc_trading_partner_maps map3,

116: msc_item_suppliers its,
117: msc_trading_partners tp,
118: msc_trading_partner_maps map,
119: msc_trading_partner_maps map2,
120: msc_trading_partner_maps map3,
121: msc_company_relationships r
122: WHERE sd1.plan_id = -1
123: -- Alloc onhand, po, asn, recpt, req
124: AND sd1.publisher_order_type in (9, 13, 15, 16, 20)

Line 159: msc_trading_partner_maps map,

155: its.supplier_site_id
156: FROM msc_sup_dem_entries sd1,
157: msc_item_suppliers its,
158: msc_trading_partners tp,
159: msc_trading_partner_maps map,
160: msc_trading_partner_maps map2,
161: msc_trading_partner_maps map3,
162: msc_company_relationships r
163: WHERE sd1.plan_id = -1

Line 160: msc_trading_partner_maps map2,

156: FROM msc_sup_dem_entries sd1,
157: msc_item_suppliers its,
158: msc_trading_partners tp,
159: msc_trading_partner_maps map,
160: msc_trading_partner_maps map2,
161: msc_trading_partner_maps map3,
162: msc_company_relationships r
163: WHERE sd1.plan_id = -1
164: -- Alloc onhand, po, asn, recpt, req

Line 161: msc_trading_partner_maps map3,

157: msc_item_suppliers its,
158: msc_trading_partners tp,
159: msc_trading_partner_maps map,
160: msc_trading_partner_maps map2,
161: msc_trading_partner_maps map3,
162: msc_company_relationships r
163: WHERE sd1.plan_id = -1
164: -- Alloc onhand, po, asn, recpt, req
165: AND sd1.publisher_order_type in (9, 13, 15, 16, 20)

Line 2969: FROM msc_trading_partner_maps map

2965: l_company_key NUMBER;
2966:
2967: CURSOR c_company_key_1 IS
2968: SELECT cr.object_id
2969: FROM msc_trading_partner_maps map
2970: , msc_company_relationships cr
2971: WHERE map.map_type = p_map_type
2972: AND map.tp_key = p_tp_key
2973: AND map.company_key = cr.relationship_id

Line 2979: FROM msc_trading_partner_maps map

2975: ;
2976:
2977: CURSOR c_company_key_2 IS
2978: SELECT map.company_key
2979: FROM msc_trading_partner_maps map
2980: , msc_trading_partners tp
2981: WHERE map.map_type = p_map_type
2982: AND tp.partner_id = map.tp_key
2983: AND tp.sr_tp_id = p_tp_key

Line 2989: FROM msc_trading_partner_maps map

2985: ;
2986:
2987: CURSOR c_company_key_3 IS
2988: SELECT map.company_key
2989: FROM msc_trading_partner_maps map
2990: WHERE map.map_type = p_map_type
2991: AND map.tp_key = p_tp_key
2992: ;
2993: BEGIN

Line 3032: FROM msc_trading_partner_maps map

3028: l_tp_key NUMBER;
3029:
3030: CURSOR c_tp_key_1 IS
3031: SELECT map.tp_key
3032: FROM msc_trading_partner_maps map
3033: , msc_company_relationships cr
3034: WHERE map.map_type = p_map_type
3035: AND cr.object_id = p_company_key
3036: AND map.company_key = cr.relationship_id

Line 3043: FROM msc_trading_partner_maps map

3039: ;
3040:
3041: CURSOR c_tp_key_2 IS
3042: SELECT tp.sr_tp_id
3043: FROM msc_trading_partner_maps map
3044: , msc_trading_partners tp
3045: WHERE map.map_type = p_map_type
3046: AND tp.partner_id = map.tp_key
3047: AND map.company_key= p_company_key

Line 3053: FROM msc_trading_partner_maps map

3049: /*AND tp.partner.partner_type = 3*/
3050:
3051: CURSOR c_tp_key_3 IS
3052: SELECT map.tp_key
3053: FROM msc_trading_partner_maps map
3054: WHERE map.map_type = p_map_type
3055: AND map.company_key = p_company_key
3056:
3057: ;

Line 3162: FROM msc_trading_partner_maps map

3158: -- l_uom_code VARCHAR2(10);
3159:
3160: CURSOR c_sr_instance_id IS
3161: SELECT tp.sr_instance_id
3162: FROM msc_trading_partner_maps map
3163: , msc_trading_partners tp
3164: WHERE map.map_type = ORGANIZATION_MAPPING
3165: AND tp.partner_id = map.tp_key
3166: AND map.company_key= p_customer_site_id

Line 3224: from msc_trading_partner_maps maps,

3220: l_aps_supplier_site_id := sce_to_aps(p_supplier_site_id, SITE_MAPPING);
3221:
3222: select tp.sr_instance_id
3223: into l_sr_instance_id
3224: from msc_trading_partner_maps maps,
3225: msc_trading_partners tp
3226: where maps.tp_key = tp.partner_id
3227: and maps.company_key = p_customer_site_id
3228: and maps.map_type = 2

Line 3565: from msc_trading_partner_maps map1,

3561: object_id,
3562: tp_key
3563: )
3564: select distinct r.object_id, map1.tp_key
3565: from msc_trading_partner_maps map1,
3566: msc_company_relationships r,
3567: msc_item_suppliers its
3568: where map1.map_type = 1
3569: AND map1.company_key = r.relationship_id

Line 3586: from msc_trading_partner_maps map2,

3582: company_key,
3583: sr_tp_id
3584: )
3585: select distinct map2.company_key,tp.sr_tp_id
3586: from msc_trading_partner_maps map2,
3587: msc_trading_partners tp,
3588: msc_item_suppliers its
3589: where map2.map_type = 2
3590: AND map2.tp_key = tp.partner_id

Line 3608: from msc_trading_partner_maps map3,

3604: company_key,
3605: tp_key
3606: )
3607: select distinct map3.company_key, map3.tp_key
3608: from msc_trading_partner_maps map3,
3609: msc_item_suppliers its
3610: where map3.map_type = 3
3611: AND map3.tp_key = its.supplier_site_id
3612: AND its.plan_id = -1