APPS.MSC_X_REPLENISH dependencies on MSC_TRADING_PARTNERS

Line 117: msc_trading_partners tp,

113: its.supplier_id,
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

Line 158: msc_trading_partners tp,

154: its.supplier_id,
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

Line 2391: msc_trading_partners tp,

2387: si.sr_instance_id, -- sr_instance_id
2388: 1 -- vmi_flag
2389: FROM msc_sup_dem_entries sd,
2390: msc_system_items si,
2391: msc_trading_partners tp,
2392: msc_tp_id_lid tplid,
2393: msc_trading_partner_sites tps,
2394: msc_trading_partner_sites tps2
2395: , MSC_TP_SITE_ID_LID mtsil

Line 2980: , msc_trading_partners tp

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
2984: AND tp.sr_instance_id = p_sr_instance_id

Line 3044: , msc_trading_partners tp

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
3048: ;

Line 3163: , msc_trading_partners tp

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
3167: ;

Line 3225: msc_trading_partners tp

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
3229: and tp.partner_type = 3;

Line 3381: msc_trading_partners tp,

3377: to_char(NULL), -- project_accounting_context
3378: si.sr_instance_id, -- sr_instance_id
3379: 1 -- vmi_flag
3380: FROM msc_system_items si,
3381: msc_trading_partners tp,
3382: msc_tp_id_lid tplid,
3383: msc_trading_partner_sites tps,
3384: msc_trading_partner_sites tps2
3385: , MSC_TP_SITE_ID_LID mtsil

Line 3448: msc_trading_partners tp,

3444: to_char(NULL), -- project_accounting_context
3445: si.sr_instance_id, -- sr_instance_id
3446: 2 -- vmi_flag
3447: FROM msc_system_items si,
3448: msc_trading_partners tp,
3449: msc_trading_partner_sites tps
3450: WHERE si.organization_id = l_aps_customer_site_id
3451: AND si.inventory_item_id = p_item_id
3452: AND si.plan_id = VMI_PLAN_ID

Line 3587: msc_trading_partners tp,

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
3591: AND tp.partner_type = 3