APPS.MSC_WF_ALLOC_ATP dependencies on MSC_TRADING_PARTNER_SITES

Line 332: -- msc_trading_partner_sites directly,we need to join to id_lid

328: avalue => LEAST(p_requested_qty, NVL(p_request_date_qty,0)) -
329: NVL(p_stolen_qty, 0));
330:
331: -- bug 1831563. instead of using msc_trading_partners and
332: -- msc_trading_partner_sites directly,we need to join to id_lid
333:
334: SELECT tp.customer_class_code, tp.partner_name,
335: tps.location, tps.partner_address
336: INTO l_customer_class, l_customer, l_location, l_address

Line 340: msc_trading_partner_sites tps

336: INTO l_customer_class, l_customer, l_location, l_address
337: FROM msc_tp_id_lid tplid,
338: msc_trading_partners tp,
339: msc_tp_site_id_lid tpslid,
340: msc_trading_partner_sites tps
341: WHERE tplid.sr_tp_id = p_customer_id
342: AND tplid.sr_instance_id = p_instance_id
343: AND tplid.partner_type = 2
344: AND tpslid.sr_tp_site_id = p_customer_site_id

Line 622: -- msc_trading_partner_sites directly,we need to join to id_lid

618: avalue => p_available_date);
619:
620:
621: -- bug 1831563. instead of using msc_trading_partners and
622: -- msc_trading_partner_sites directly,we need to join to id_lid
623:
624: SELECT tp.customer_class_code, tp.partner_name,
625: tps.location, tps.partner_address
626: INTO l_customer_class, l_customer, l_location, l_address

Line 630: msc_trading_partner_sites tps

626: INTO l_customer_class, l_customer, l_location, l_address
627: FROM msc_tp_id_lid tplid,
628: msc_trading_partners tp,
629: msc_tp_site_id_lid tpslid,
630: msc_trading_partner_sites tps
631: WHERE tplid.sr_tp_id = p_customer_id
632: AND tplid.sr_instance_id = p_instance_id
633: AND tplid.partner_type = 2
634: AND tpslid.sr_tp_site_id = p_customer_site_id