APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_TRADING_PARTNER_MAPS

Line 1500: msc_trading_partner_maps m,

1496: ) IS
1497: select distinct mis.processing_lead_time,
1498: mis.using_organization_id
1499: from msc_item_suppliers mis,
1500: msc_trading_partner_maps m,
1501: msc_trading_partner_maps m2,
1502: msc_company_relationships r
1503: where mis.plan_id = -1 and
1504: mis.inventory_item_id = p_item_id and

Line 1501: msc_trading_partner_maps m2,

1497: select distinct mis.processing_lead_time,
1498: mis.using_organization_id
1499: from msc_item_suppliers mis,
1500: msc_trading_partner_maps m,
1501: msc_trading_partner_maps m2,
1502: msc_company_relationships r
1503: where mis.plan_id = -1 and
1504: mis.inventory_item_id = p_item_id and
1505: mis.organization_id = p_org_id and

Line 1545: msc_trading_partner_maps m,

1541: t_pub_site_id(j),
1542: t_pub_site(j)
1543: from msc_companies c,
1544: msc_company_sites s,
1545: msc_trading_partner_maps m,
1546: msc_trading_partners t
1547: where t.sr_tp_id = t_org_id(j) and
1548: t.sr_instance_id = t_sr_instance_id(j) and
1549: t.partner_type = 3 and

Line 1577: msc_trading_partner_maps m,

1573: into t_supp_id(j),
1574: t_supp(j)
1575: from msc_companies c,
1576: msc_company_sites s,
1577: msc_trading_partner_maps m,
1578: msc_company_relationships r
1579: where m.tp_key = t_source_supp_id(j) and
1580: m.map_type = 1 and
1581: r.relationship_id = m.company_key and

Line 1603: msc_trading_partner_maps m

1599: s.company_site_name
1600: into t_supp_site_id(j),
1601: t_supp_site(j)
1602: from msc_company_sites s,
1603: msc_trading_partner_maps m
1604: where m.tp_key = t_source_supp_site_id(j) and
1605: m.map_type = 3 and
1606: s.company_site_id = m.company_key and
1607: s.company_id = t_supp_id(j);

Line 1647: msc_trading_partner_maps map

1643: t_supp_item_desc(j),
1644: t_tp_uom(j)
1645: from msc_system_items msi,
1646: msc_trading_partners part,
1647: msc_trading_partner_maps map
1648: where msi.plan_id = -1 and
1649: msi.inventory_item_id = t_item_id(j) and
1650: msi.organization_id = part.sr_tp_id and
1651: msi.sr_instance_id = part.sr_instance_id and

Line 1667: msc_trading_partner_maps m,

1663: into t_supp_item_name(j),
1664: t_supp_item_desc(j),
1665: t_tp_uom(j)
1666: from msc_item_suppliers mis,
1667: msc_trading_partner_maps m,
1668: msc_trading_partner_maps m2,
1669: msc_company_relationships r
1670: where mis.plan_id = -1 and
1671: mis.inventory_item_id = t_item_id(j) and

Line 1668: msc_trading_partner_maps m2,

1664: t_supp_item_desc(j),
1665: t_tp_uom(j)
1666: from msc_item_suppliers mis,
1667: msc_trading_partner_maps m,
1668: msc_trading_partner_maps m2,
1669: msc_company_relationships r
1670: where mis.plan_id = -1 and
1671: mis.inventory_item_id = t_item_id(j) and
1672: mis.organization_id = t_org_id(j) and

Line 5076: from msc_trading_partner_maps m,

5072: if p_supplier_id is not null then
5073: BEGIN
5074: select c.company_id
5075: into l_supplier_id
5076: from msc_trading_partner_maps m,
5077: msc_company_relationships r,
5078: msc_companies c
5079: where m.tp_key = p_supplier_id and
5080: m.map_type = 1 and

Line 5101: from msc_trading_partner_maps m,

5097: if p_supplier_site_id is not null then
5098: BEGIN
5099: select cs.company_site_id
5100: into l_supplier_site_id
5101: from msc_trading_partner_maps m,
5102: msc_company_sites cs
5103: where m.tp_key = p_supplier_site_id and
5104: m.map_type = 3 and
5105: cs.company_site_id = m.company_key;

Line 5129: msc_trading_partner_maps m,

5125: sd.publisher_id = 1 and
5126: exists (select cs.company_site_id
5127: from msc_plan_organizations o,
5128: msc_company_sites cs,
5129: msc_trading_partner_maps m,
5130: msc_trading_partners p
5131: where o.plan_id = p_plan_id
5132: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)
5133: AND O.SR_INSTANCE_ID = NVL(p_sr_instance_id , O.SR_INSTANCE_ID)

Line 5175: msc_trading_partner_maps m,

5171: sd.publisher_id = 1 and
5172: exists (select cs.company_site_id
5173: from msc_plan_organizations o,
5174: msc_company_sites cs,
5175: msc_trading_partner_maps m,
5176: msc_trading_partners p
5177: where o.plan_id = p_plan_id and
5178: p.sr_tp_id = nvl(p_org_id, o.organization_id) and
5179: p.sr_instance_id = nvl(p_sr_instance_id,