APPS.MSC_REL_PLAN_PUB dependencies on MSC_TP_ID_LID

Line 440: FROM MSC_TP_ID_LID

436: BEGIN
437:
438: SELECT SR_TP_ID
439: INTO lv_mod_sup_sr_tp_id
440: FROM MSC_TP_ID_LID
441: WHERE TP_ID = pMODELED_SUPPLIER_ID
442: AND SR_INSTANCE_ID = pSR_INSTANCE_ID
443: AND PARTNER_TYPE = 1;
444:

Line 8790: msc_tp_id_lid supplier,

8786: s.sr_instance_id
8787: FROM msc_projects mpp,
8788: --msc_calendar_dates cal1,
8789: --msc_calendar_dates cal2,
8790: msc_tp_id_lid supplier,
8791: msc_trading_partner_sites mtps,
8792: msc_trading_partners mp, -- mtl_parameters mp,
8793: msc_trading_partners mp1,
8794: msc_system_items msi,

Line 8933: msc_tp_id_lid supplier,

8929: s.sr_instance_id
8930: FROM msc_projects mpp,
8931: -- msc_calendar_dates cal1,
8932: -- msc_calendar_dates cal2,
8933: msc_tp_id_lid supplier,
8934: msc_trading_partner_sites mtps,
8935: msc_trading_partners mp, -- mtl_parameters mp,
8936: msc_trading_partners mp1,
8937: msc_system_items msi,

Line 9075: msc_tp_id_lid supplier,

9071: s.sr_instance_id
9072: FROM msc_projects mpp,
9073: -- msc_calendar_dates cal1,
9074: -- msc_calendar_dates cal2,
9075: msc_tp_id_lid supplier,
9076: msc_trading_partner_sites mtps,
9077: msc_trading_partners mp, -- mtl_parameters mp,
9078: msc_trading_partners mp1,
9079: msc_system_items msi,