APPS.INV_MWB_QUERY_MANAGER dependencies on PO_VENDORS

Line 1877: FROM po_vendors

1873: IF rec.vendor_id IS NOT NULL
1874: OR l_vendor_id IS NOT NULL THEN
1875: UPDATE mtl_mwb_gtmp
1876: SET trading_partner = (SELECT vendor_name
1877: FROM po_vendors
1878: WHERE vendor_id = l_vendor_id)
1879: WHERE vendor_id = l_vendor_id;
1880:
1881: IF rec.vendor_site_id IS NOT NULL

Line 1938: FROM po_vendor_sites_all ps, po_vendors pv

1934: SET planning_party = inv_mwb_globals.g_planning_party;
1935: ELSE
1936: UPDATE mtl_mwb_gtmp
1937: SET planning_party = (SELECT vendor_name || '-' || vendor_site_code
1938: FROM po_vendor_sites_all ps, po_vendors pv
1939: WHERE pv.vendor_id = ps.vendor_id
1940: AND ps.vendor_site_id = rec.planning_organization_id)
1941: WHERE planning_organization_id = rec.planning_organization_id;
1942: END IF;

Line 1954: FROM po_vendor_sites_all ps, po_vendors pv

1950: SET owning_party = inv_mwb_globals.g_owning_party;
1951: ELSE
1952: UPDATE mtl_mwb_gtmp
1953: SET owning_party = (SELECT vendor_name || '-' || vendor_site_code
1954: FROM po_vendor_sites_all ps, po_vendors pv
1955: WHERE pv.vendor_id = ps.vendor_id
1956: AND ps.vendor_site_id = rec.owning_organization_id)
1957: WHERE owning_organization_id = rec.owning_organization_id;
1958: END IF;