APPS.MSC_REL_PLAN_PUB dependencies on MSC_TP_ID_LID

Line 448: FROM MSC_TP_ID_LID

444: BEGIN
445:
446: SELECT SR_TP_ID
447: INTO lv_mod_sup_sr_tp_id
448: FROM MSC_TP_ID_LID
449: WHERE TP_ID = pMODELED_SUPPLIER_ID
450: AND SR_INSTANCE_ID = pSR_INSTANCE_ID
451: AND PARTNER_TYPE = 1;
452:

Line 9650: msc_tp_id_lid supplier,

9646: s.sr_instance_id
9647: FROM msc_projects mpp,
9648: --msc_calendar_dates cal1,
9649: --msc_calendar_dates cal2,
9650: msc_tp_id_lid supplier,
9651: msc_trading_partner_sites mtps,
9652: msc_trading_partners mp, -- mtl_parameters mp,
9653: msc_trading_partners mp1,
9654: msc_system_items msi,

Line 9796: msc_tp_id_lid supplier,

9792: s.sr_instance_id
9793: FROM msc_projects mpp,
9794: -- msc_calendar_dates cal1,
9795: -- msc_calendar_dates cal2,
9796: msc_tp_id_lid supplier,
9797: msc_trading_partner_sites mtps,
9798: msc_trading_partners mp, -- mtl_parameters mp,
9799: msc_trading_partners mp1,
9800: msc_system_items msi,

Line 9941: msc_tp_id_lid supplier,

9937: s.sr_instance_id
9938: FROM msc_projects mpp,
9939: -- msc_calendar_dates cal1,
9940: -- msc_calendar_dates cal2,
9941: msc_tp_id_lid supplier,
9942: msc_trading_partner_sites mtps,
9943: msc_trading_partners mp, -- mtl_parameters mp,
9944: msc_trading_partners mp1,
9945: msc_system_items msi,