APPS.MSC_REL_PLAN_PUB dependencies on MSC_TRADING_PARTNER_SITES

Line 471: FROM MSC_TRADING_PARTNER_SITES

467: BEGIN
468:
469: SELECT TP_SITE_CODE
470: INTO lv_mod_sup_site_code
471: FROM MSC_TRADING_PARTNER_SITES
472: WHERE PARTNER_ID = pMODELED_SUPPLIER_ID
473: AND PARTNER_SITE_ID = pMODELED_SUPPLIER_SITE_ID
474: AND SR_INSTANCE_ID = pSR_INSTANCE_ID
475: AND PARTNER_TYPE = 1;

Line 9651: msc_trading_partner_sites mtps,

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

Line 9797: msc_trading_partner_sites mtps,

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

Line 9942: msc_trading_partner_sites mtps,

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