[Home] [Help]
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
138: AND map.tp_key = con.partner_site_id
139: AND map1.company_key =p_oem_site_id
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
165: AND map.tp_key = con.partner_site_id
166: AND site.company_id = p_company_id
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
177: AND map.company_key = rel.relationship_id
178: AND rel.relationship_type = 2 --supplier
179: AND rel.object_id = c.company_id
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
200: AND map.company_key = rel.relationship_id
201: AND rel.relationship_type = 1 --customer
202: AND rel.object_id = c.company_id
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
227: AND map.company_key = rel.relationship_id
228: AND rel.relationship_type = 2 --supplier
229: AND rel.object_id = c.company_id
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
240: AND map.company_key = rel.relationship_id
241: AND rel.relationship_type = 1 --customer
242: AND rel.object_id = c.company_id
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
556: AND map.tp_key = con.partner_site_id
557: AND map1.company_key =decode(t_supplier_id(j),1,t_supplier_site_id(j),t_customer_site_id(j))
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
581: AND map.tp_key = con.partner_site_id
582: AND site.company_id = t_company_id(j)
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
718: AND map.company_key = rel.relationship_id
719: AND (rel.relationship_type = 2 --supplier
720: OR rel.relationship_type = 1) --customer
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
749: AND map.company_key = rel.relationship_id
750: AND (rel.relationship_type = 2 --supplier
751: OR rel.relationship_type = 1) --customer
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
1607: AND map.tp_key = con.partner_site_id
1608: AND site.company_id = p_company_id
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
1619: AND map.company_key = site.company_site_id
1620: AND map.tp_key = tps.partner_site_id