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_PLAN_RELEASE dependencies on MSC_TRADING_PARTNERS

Line 818: FROM msc_trading_partners

814: l_count NUMBER;
815:
816: CURSOR C1 IS
817: SELECT count(1)
818: FROM msc_trading_partners
819: WHERE sr_tp_id = p_org_id
820: AND sr_instance_id = p_inst_id
821: AND (modeled_customer_id is not null
822: OR modeled_supplier_id is not null);

Line 889: from msc_trading_partners mtp,

885: AND mp.current_employee_flag = 1;
886:
887: CURSOR loc_C IS
888: select mtps.sr_tp_site_id
889: from msc_trading_partners mtp,
890: msc_trading_partner_sites mtps
891: where mtp.sr_tp_id = p_org_id
892: AND mtp.sr_instance_id = p_inst_id
893: AND mtp.partner_type =3

Line 1113: FROM msc_trading_partners

1109:
1110:
1111: CURSOR C1 IS
1112: SELECT partner_id
1113: FROM msc_trading_partners
1114: WHERE partner_type = 3
1115: AND sr_tp_id = p_org_id
1116: AND sr_instance_id = p_inst_id;
1117: