[Home] [Help]
103: p_company_site_id in Number,
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
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
138: AND map.tp_key = con.partner_site_id
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
165: AND map.tp_key = con.partner_site_id
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
556: AND map.tp_key = con.partner_site_id
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
581: AND map.tp_key = con.partner_site_id
1376: sd.plan_id = -1 and
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)
1402: r.relationship_type = 2 and
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
1506: sd.plan_id = -1 and
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
1529: r.subject_id = 1 and
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
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
1607: AND map.tp_key = con.partner_site_id
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
1619: AND map.company_key = site.company_site_id