DBA Data[Home] [Help]

APPS.MSC_X_REPLENISH dependencies on MSC_TP_SITE_ID_LID

Line 2395: , MSC_TP_SITE_ID_LID mtsil

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
2399: AND sd.publisher_order_type = REPLENISHMENT

Line 3385: , MSC_TP_SITE_ID_LID mtsil

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