APPS.MSC_X_REPLENISH dependencies on MSC_TRADING_PARTNER_SITES

Line 2393: msc_trading_partner_sites tps,

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
2396: WHERE sd.transaction_id = l_rep_transaction_id -- l_req_transaction_id
2397: AND sd.publisher_site_id = l_sce_organization_id

Line 2394: msc_trading_partner_sites tps2

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
2396: WHERE sd.transaction_id = l_rep_transaction_id -- l_req_transaction_id
2397: AND sd.publisher_site_id = l_sce_organization_id
2398: AND sd.inventory_item_id = l_inventory_item_id

Line 3383: msc_trading_partner_sites tps,

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
3386: WHERE si.organization_id = l_aps_customer_site_id
3387: AND si.inventory_item_id = p_item_id

Line 3384: msc_trading_partner_sites tps2

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
3386: WHERE si.organization_id = l_aps_customer_site_id
3387: AND si.inventory_item_id = p_item_id
3388: AND si.plan_id = VMI_PLAN_ID

Line 3449: msc_trading_partner_sites tps

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
3453: AND si.sr_instance_id = l_sr_instance_id