eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_RP_RELEASE_PUB dependencies on MSC_TRADING_PARTNERS

Line 708: FROM msc_trading_partners

704: l_count NUMBER;
705:
706: CURSOR C1 IS
707: SELECT count(1)
708: FROM msc_trading_partners
709: WHERE sr_tp_id = p_org_id
710: AND sr_instance_id = p_inst_id
711: AND (modeled_customer_id is not null
712: OR modeled_supplier_id is not null);

Line 779: from msc_trading_partners mtp,

775: AND mp.current_employee_flag = 1;
776:
777: CURSOR loc_C IS
778: select mtps.sr_tp_site_id
779: from msc_trading_partners mtp,
780: msc_trading_partner_sites mtps
781: where mtp.sr_tp_id = p_org_id
782: AND mtp.sr_instance_id = p_inst_id
783: AND mtp.partner_type =3

Line 992: FROM msc_trading_partners

988:
989:
990: CURSOR C1 IS
991: SELECT partner_id
992: FROM msc_trading_partners
993: WHERE partner_type = 3
994: AND sr_tp_id = p_org_id
995: AND sr_instance_id = p_inst_id;
996: