APPS.INV_MWB_QUERY_MANAGER dependencies on PO_VENDOR_SITES_ALL

Line 1885: FROM po_vendor_sites_all

1881: IF rec.vendor_site_id IS NOT NULL
1882: OR l_vendor_site_id IS NOT NULL THEN
1883: UPDATE mtl_mwb_gtmp
1884: SET trading_partner_site = (SELECT vendor_site_code
1885: FROM po_vendor_sites_all
1886: WHERE vendor_site_id = l_vendor_site_id)
1887: WHERE vendor_id = l_vendor_id
1888: AND vendor_site_id = l_vendor_site_id;
1889: END IF;

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;