[Home] [Help]
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
177: AND map.company_key = rel.relationship_id
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
200: AND map.company_key = rel.relationship_id
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
227: AND map.company_key = rel.relationship_id
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
240: AND map.company_key = rel.relationship_id
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
718: AND map.company_key = rel.relationship_id
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
749: AND map.company_key = rel.relationship_id
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
1401: r.subject_id = 1 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
1529: r.subject_id = 1 and