[Home] [Help]
1481: mis.using_organization_id
1482: from msc_item_suppliers mis,
1483: msc_trading_partner_maps m,
1484: msc_trading_partner_maps m2,
1485: msc_company_relationships r
1486: where mis.plan_id = -1 and
1487: mis.inventory_item_id = p_item_id and
1488: mis.organization_id = p_org_id and
1489: mis.sr_instance_id = p_inst_id and
1557: t_supp(j)
1558: from msc_companies c,
1559: msc_company_sites s,
1560: msc_trading_partner_maps m,
1561: msc_company_relationships r
1562: where m.tp_key = t_source_supp_id(j) and
1563: m.map_type = 1 and
1564: r.relationship_id = m.company_key and
1565: r.subject_id = t_pub_id(j) and
1648: t_tp_uom(j)
1649: from msc_item_suppliers mis,
1650: msc_trading_partner_maps m,
1651: msc_trading_partner_maps m2,
1652: msc_company_relationships r
1653: where mis.plan_id = -1 and
1654: mis.inventory_item_id = t_item_id(j) and
1655: mis.organization_id = t_org_id(j) and
1656: mis.sr_instance_id = t_sr_instance_id(j) and
5056: BEGIN
5057: select c.company_id
5058: into l_supplier_id
5059: from msc_trading_partner_maps m,
5060: msc_company_relationships r,
5061: msc_companies c
5062: where m.tp_key = p_supplier_id and
5063: m.map_type = 1 and
5064: m.company_key = r.relationship_id and