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_X_WFNOTIFY_PKG dependencies on MSC_TRADING_PARTNER_MAPS

Line 108: msc_trading_partner_maps map,

104: p_item_id in Number) IS
105: SELECT distinct pl.user_name
106: FROM msc_system_items msi,
107: msc_company_sites s,
108: msc_trading_partner_maps map,
109: msc_trading_partners part,
110: msc_planners pl
111: WHERE s.company_id = 1
112: AND s.company_site_id = p_company_site_id

Line 132: FROM msc_trading_partner_maps map,

128: ---------------------------------------------------------*/
129: CURSOR partner_con_by_site_c(p_company_id in number,
130: p_company_site_id in Number,p_oem_site_id in NUMBER,p_inventory_item_id in NUMBER) IS
131: SELECT distinct con.name
132: FROM msc_trading_partner_maps map,
133: msc_trading_partner_maps map1,
134: msc_company_sites site,
135: msc_partner_contacts con
136: WHERE map.map_type = 3

Line 133: msc_trading_partner_maps map1,

129: CURSOR partner_con_by_site_c(p_company_id in number,
130: p_company_site_id in Number,p_oem_site_id in NUMBER,p_inventory_item_id in NUMBER) IS
131: SELECT distinct con.name
132: FROM msc_trading_partner_maps map,
133: msc_trading_partner_maps map1,
134: msc_company_sites site,
135: msc_partner_contacts con
136: WHERE map.map_type = 3
137: AND map.company_key = site.company_site_id

Line 160: msc_trading_partner_maps map,

156: p_company_site_id in NUMBER) IS
157: SELECT
158: distinct con.name
159: FROM
160: msc_trading_partner_maps map,
161: msc_company_sites site,
162: msc_partner_contacts con
163: WHERE map.map_type = 3
164: AND map.company_key = site.company_site_id

Line 171: FROM msc_trading_partner_maps map,

167: AND site.company_site_id = p_company_site_id; -- Bug #6242828
168:
169: CURSOR partner_con_by_comp_c(p_company_id in number, p_oem_id in number,p_inventory_item_id in number) IS
170: SELECT distinct con.name
171: FROM msc_trading_partner_maps map,
172: msc_trading_partner_maps map1,
173: msc_company_relationships rel,
174: msc_companies c,
175: msc_partner_contacts con

Line 172: msc_trading_partner_maps map1,

168:
169: CURSOR partner_con_by_comp_c(p_company_id in number, p_oem_id in number,p_inventory_item_id in number) IS
170: SELECT distinct con.name
171: FROM msc_trading_partner_maps map,
172: msc_trading_partner_maps map1,
173: msc_company_relationships rel,
174: msc_companies c,
175: msc_partner_contacts con
176: WHERE map.map_type = 1 --company

Line 194: FROM msc_trading_partner_maps map,

190: and mt.sr_tp_id = msi.organization_id
191: and mt.partner_type=3)
192: UNION
193: SELECT distinct con.name
194: FROM msc_trading_partner_maps map,
195: msc_trading_partner_maps map1,
196: msc_company_relationships rel,
197: msc_companies c,
198: msc_partner_contacts con

Line 195: msc_trading_partner_maps map1,

191: and mt.partner_type=3)
192: UNION
193: SELECT distinct con.name
194: FROM msc_trading_partner_maps map,
195: msc_trading_partner_maps map1,
196: msc_company_relationships rel,
197: msc_companies c,
198: msc_partner_contacts con
199: WHERE map.map_type = 1 --company

Line 222: FROM msc_trading_partner_maps map,

218: ---------------------------------------------------------------------------------*/
219:
220: CURSOR partner_con_by_comp_c1(p_company_id in number) IS
221: SELECT distinct con.name
222: FROM msc_trading_partner_maps map,
223: msc_company_relationships rel,
224: msc_companies c,
225: msc_partner_contacts con
226: WHERE map.map_type = 1 --company

Line 235: FROM msc_trading_partner_maps map,

231: AND con.partner_type = 1 --suplier
232: AND c.company_id = p_company_id
233: UNION
234: SELECT distinct con.name
235: FROM msc_trading_partner_maps map,
236: msc_company_relationships rel,
237: msc_companies c,
238: msc_partner_contacts con
239: WHERE map.map_type = 1 --company

Line 550: FROM msc_trading_partner_maps map,

546: ELSE
547: begin
548: SELECT 1 into l_exist from dual
549: WHERE exists (SELECT 1
550: FROM msc_trading_partner_maps map,
551: msc_trading_partner_maps map1,
552: msc_company_sites site,
553: msc_partner_contacts con
554: WHERE map.map_type = 3

Line 551: msc_trading_partner_maps map1,

547: begin
548: SELECT 1 into l_exist from dual
549: WHERE exists (SELECT 1
550: FROM msc_trading_partner_maps map,
551: msc_trading_partner_maps map1,
552: msc_company_sites site,
553: msc_partner_contacts con
554: WHERE map.map_type = 3
555: AND map.company_key = site.company_site_id

Line 576: FROM msc_trading_partner_maps map,

572: BEGIN
573: SELECT 1 into l_exist
574: FROM dual
575: WHERE exists (SELECT 1
576: FROM msc_trading_partner_maps map,
577: msc_company_sites site,
578: msc_partner_contacts con
579: WHERE map.map_type = 3
580: AND map.company_key = site.company_site_id

Line 712: FROM msc_trading_partner_maps map,

708: BEGIN
709: SELECT 0 into l_independent
710: FROM dual
711: WHERE exists (SELECT 1
712: FROM msc_trading_partner_maps map,
713: msc_trading_partner_maps map1,
714: msc_company_relationships rel,
715: msc_companies c,
716: msc_partner_contacts con

Line 713: msc_trading_partner_maps map1,

709: SELECT 0 into l_independent
710: FROM dual
711: WHERE exists (SELECT 1
712: FROM msc_trading_partner_maps map,
713: msc_trading_partner_maps map1,
714: msc_company_relationships rel,
715: msc_companies c,
716: msc_partner_contacts con
717: WHERE map.map_type = 1 --company

Line 744: FROM msc_trading_partner_maps map,

740: BEGIN
741: SELECT 1 into l_independent
742: FROM dual
743: WHERE EXISTS (SELECT 1
744: FROM msc_trading_partner_maps map,
745: msc_company_relationships rel,
746: msc_companies c,
747: msc_partner_contacts con
748: WHERE map.map_type = 1 --company

Line 1381: msc_trading_partner_maps m,

1377: sd.publisher_id = 1 and
1378: exists (select cs.company_site_id
1379: from msc_plan_organizations o,
1380: msc_company_sites cs,
1381: msc_trading_partner_maps m,
1382: msc_trading_partners p
1383: where o.plan_id = p_plan_id
1384: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)
1385: AND O.SR_INSTANCE_ID = NVL(p_sr_instance_id , O.SR_INSTANCE_ID)

Line 1396: msc_trading_partner_maps m,

1392: cs.company_id = 1
1393: and sd.publisher_site_id =cs.company_site_id and rownum=1) and
1394: exists (select c.company_id
1395: from msc_companies c,
1396: msc_trading_partner_maps m,
1397: msc_company_relationships r
1398: where m.tp_key = nvl(p_supplier_id, m.tp_key) and
1399: m.map_type = 1 and
1400: r.relationship_id = m.company_key and

Line 1407: msc_trading_partner_maps m

1403: c.company_id = r.object_id and
1404: sd.supplier_id =c.company_id and rownum=1) and
1405: exists (select s.company_site_id
1406: from msc_company_sites s,
1407: msc_trading_partner_maps m
1408: where m.tp_key = nvl(p_supplier_site_id, m.tp_key) and
1409: m.map_type = 3 and
1410: s.company_site_id = m.company_key and
1411: s.company_id = sd.supplier_id and

Line 1511: msc_trading_partner_maps m,

1507: sd.publisher_id = 1 and
1508: sd.publisher_site_id IN (select cs.company_site_id
1509: from msc_plan_organizations o,
1510: msc_company_sites cs,
1511: msc_trading_partner_maps m,
1512: msc_trading_partners p
1513: where o.plan_id = p_plan_id and
1514: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
1515: p.sr_instance_id = nvl(p_sr_instance_id,

Line 1524: msc_trading_partner_maps m,

1520: cs.company_site_id = m.company_key and
1521: cs.company_id = 1) and
1522: sd.customer_id IN (select distinct c.company_id
1523: from msc_companies c,
1524: msc_trading_partner_maps m,
1525: msc_company_relationships r
1526: where m.tp_key = nvl(p_customer_id, m.tp_key) and
1527: m.map_type = 1 and
1528: r.relationship_id = m.company_key and

Line 1534: msc_trading_partner_maps m

1530: r.relationship_type = 1 and
1531: c.company_id = r.object_id) and
1532: sd.customer_site_id IN (select s.company_site_id
1533: from msc_company_sites s,
1534: msc_trading_partner_maps m
1535: where m.tp_key = nvl(p_customer_site_id, m.tp_key) and
1536: m.map_type = 3 and
1537: s.company_site_id = m.company_key and
1538: s.company_id = sd.customer_id) and

Line 1602: FROM msc_trading_partner_maps map,

1598:
1599: CURSOR partner_con_by_site_c(p_company_id in number,
1600: p_company_site_id in Number) IS
1601: SELECT distinct con.name
1602: FROM msc_trading_partner_maps map,
1603: msc_company_sites site,
1604: msc_partner_contacts con
1605: WHERE map.map_type = 3
1606: AND map.company_key = site.company_site_id

Line 1614: FROM msc_trading_partner_maps map,

1610:
1611:
1612: /*
1613: SELECT distinct con.name
1614: FROM msc_trading_partner_maps map,
1615: msc_company_sites site,
1616: msc_partner_contacts con,
1617: msc_trading_partner_sites tps
1618: WHERE map.map_type = 3