DBA Data[Home] [Help]

APPS.MSC_ATP_PROC dependencies on MSC_TP_ID_LID

Line 360: FROM msc_tp_id_lid tp

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

Line 3536: FROM msc_tp_id_lid mtil,

3532: BEGIN
3533: SELECT mtil.sr_tp_id, mtp.partner_name
3534: INTO l_other_cols.sr_supplier_id(j),
3535: l_other_cols.vendor_name(j)
3536: FROM msc_tp_id_lid mtil,
3537: msc_trading_partners mtp
3538: WHERE mtil.tp_id = mtp.partner_id
3539: AND mtil.sr_instance_id = l_sources.instance_id(j)
3540: AND mtil.partner_type = 1