[Home] [Help]
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
1506: mis.sr_instance_id = p_inst_id and
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
1582: r.subject_id = t_pub_id(j) and
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
1673: mis.sr_instance_id = t_sr_instance_id(j) and
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
5081: m.company_key = r.relationship_id and