174: msc_company_sites cs,
175: msc_company_sites cs1,
176: msc_companies c,
177: msc_companies c1,
178: msc_trading_partner_maps m,
179: msc_trading_partner_maps m1,
180: msc_trading_partner_maps m2,
181: msc_trading_partners t,
182: msc_trading_partners t1,
175: msc_company_sites cs1,
176: msc_companies c,
177: msc_companies c1,
178: msc_trading_partner_maps m,
179: msc_trading_partner_maps m1,
180: msc_trading_partner_maps m2,
181: msc_trading_partners t,
182: msc_trading_partners t1,
183: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
176: msc_companies c,
177: msc_companies c1,
178: msc_trading_partner_maps m,
179: msc_trading_partner_maps m1,
180: msc_trading_partner_maps m2,
181: msc_trading_partners t,
182: msc_trading_partners t1,
183: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
184: msc_company_relationships r,
204: 1 - Suppliers
205: 2 - Customers
206: 3 - Org
207:
208: msc_trading_partner_maps.map_type
209: 1 - Trading Partners
210: 2 - Planning Org
211: 3 - Site
212:
411: msc_company_sites cs,
412: msc_company_sites cs1,
413: msc_companies c,
414: msc_companies c1,
415: msc_trading_partner_maps m,
416: msc_trading_partner_maps m1,
417: msc_trading_partner_maps m2,
418: msc_trading_partners t,
419: msc_trading_partners t1,
412: msc_company_sites cs1,
413: msc_companies c,
414: msc_companies c1,
415: msc_trading_partner_maps m,
416: msc_trading_partner_maps m1,
417: msc_trading_partner_maps m2,
418: msc_trading_partners t,
419: msc_trading_partners t1,
420: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
413: msc_companies c,
414: msc_companies c1,
415: msc_trading_partner_maps m,
416: msc_trading_partner_maps m1,
417: msc_trading_partner_maps m2,
418: msc_trading_partners t,
419: msc_trading_partners t1,
420: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
421: msc_company_relationships r,
439: 1 - Suppliers
440: 2 - Customers
441: 3 - Org
442:
443: msc_trading_partner_maps.map_type
444: 1 - Trading Partners
445: 2 - Planning Org
446: 3 - Site
447:
1172: uom_code
1173: into t_cust_item_name(j),
1174: t_tp_uom(j)
1175: from msc_item_customers mcf,
1176: msc_trading_partner_maps m,
1177: msc_trading_partner_maps m2,
1178: msc_company_relationships r
1179: where mcf.inventory_item_id = t_item_id(j) and
1180: r.relationship_type = 1 and
1173: into t_cust_item_name(j),
1174: t_tp_uom(j)
1175: from msc_item_customers mcf,
1176: msc_trading_partner_maps m,
1177: msc_trading_partner_maps m2,
1178: msc_company_relationships r
1179: where mcf.inventory_item_id = t_item_id(j) and
1180: r.relationship_type = 1 and
1181: r.subject_id = t_pub_id(j) and
1447: if p_source_customer_id is not null then
1448: BEGIN
1449: select c.company_id
1450: into l_customer_id
1451: from msc_trading_partner_maps m,
1452: msc_company_relationships r,
1453: msc_companies c
1454: where m.tp_key = p_source_customer_id and
1455: m.map_type = 1 and
1472: if p_source_customer_site_id is not null then
1473: BEGIN
1474: select cs.company_site_id
1475: into l_customer_site_id
1476: from msc_trading_partner_maps m,
1477: msc_company_sites cs
1478: where m.tp_key = p_source_customer_site_id and
1479: m.map_type = 3 and
1480: cs.company_site_id = m.company_key;
1497: sd.publisher_id = 1 and
1498: sd.publisher_site_id IN (select cs.company_site_id
1499: from msc_plan_organizations o,
1500: msc_company_sites cs,
1501: msc_trading_partner_maps m,
1502: msc_trading_partners p
1503: where o.plan_id = p_plan_id and
1504: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
1505: p.sr_instance_id = nvl(p_sr_instance_id, o.sr_instance_id) and
1540: sd.publisher_id = 1 and
1541: sd.publisher_site_id IN (select cs.company_site_id
1542: from msc_plan_organizations o,
1543: msc_company_sites cs,
1544: msc_trading_partner_maps m,
1545: msc_trading_partners p
1546: where o.plan_id = p_plan_id and
1547: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
1548: p.sr_instance_id = nvl(p_sr_instance_id, o.sr_instance_id) and