DBA Data[Home] [Help]

APPS.MSC_WF_ALLOC_ATP dependencies on MSC_TP_ID_LID

Line 337: FROM msc_tp_id_lid tplid,

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
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

Line 627: FROM msc_tp_id_lid tplid,

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
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