DBA Data[Home] [Help]

APPS.MSC_WF_ALLOC_ATP dependencies on MSC_TP_SITE_ID_LID

Line 339: msc_tp_site_id_lid tpslid,

335: tps.location, tps.partner_address
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

Line 629: msc_tp_site_id_lid tpslid,

625: tps.location, tps.partner_address
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