DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_TP_ID_LID

Line 361: FROM msc_tp_id_lid tp

357: IF (p_customer_id is not null) and (p_customer_site_id is not null) THEN
358: BEGIN
359: SELECT TP_ID
360: INTO l_customer_id
361: FROM msc_tp_id_lid tp
362: WHERE tp.SR_TP_ID = p_customer_id
363: AND tp.SR_INSTANCE_ID = p_instance_id
364: AND tp.PARTNER_TYPE = 2;
365:

Line 3545: FROM msc_tp_id_lid mtil,

3541: BEGIN
3542: SELECT mtil.sr_tp_id, mtp.partner_name
3543: INTO l_other_cols.sr_supplier_id(j),
3544: l_other_cols.vendor_name(j)
3545: FROM msc_tp_id_lid mtil,
3546: msc_trading_partners mtp
3547: WHERE mtil.tp_id = mtp.partner_id
3548: AND mtil.sr_instance_id = l_sources.instance_id(j)
3549: AND mtil.partner_type = 1