APPS.MSC_X_WFNOTIFY_PKG dependencies on MSC_COMPANIES

Line 174: msc_companies c,

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
178: AND rel.relationship_type = 2 --supplier

Line 197: msc_companies c,

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
201: AND rel.relationship_type = 1 --customer

Line 224: msc_companies c,

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
228: AND rel.relationship_type = 2 --supplier

Line 237: msc_companies c,

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
241: AND rel.relationship_type = 1 --customer

Line 715: msc_companies c,

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
719: AND (rel.relationship_type = 2 --supplier

Line 746: msc_companies c,

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
750: AND (rel.relationship_type = 2 --supplier

Line 1395: from msc_companies c,

1391: cs.company_site_id = m.company_key and
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

Line 1523: from msc_companies c,

1519: m.map_type = 2 and
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