APPS.MSC_REL_PLAN_PUB dependencies on MSC_TRADING_PARTNER_SITES

Line 463: FROM MSC_TRADING_PARTNER_SITES

459: BEGIN
460:
461: SELECT TP_SITE_CODE
462: INTO lv_mod_sup_site_code
463: FROM MSC_TRADING_PARTNER_SITES
464: WHERE PARTNER_ID = pMODELED_SUPPLIER_ID
465: AND PARTNER_SITE_ID = pMODELED_SUPPLIER_SITE_ID
466: AND SR_INSTANCE_ID = pSR_INSTANCE_ID
467: AND PARTNER_TYPE = 1;

Line 8791: msc_trading_partner_sites mtps,

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,
8795: msc_system_items msi1,

Line 8934: msc_trading_partner_sites mtps,

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,
8938: msc_system_items msi1,

Line 9076: msc_trading_partner_sites mtps,

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,
9080: msc_system_items msi1,