APPS.INV_MWB_QUERY_MANAGER dependencies on PO_VENDOR_SITES_ALL

Line 1783: FROM po_vendor_sites_all

1779: IF rec.vendor_site_id IS NOT NULL
1780: OR l_vendor_site_id IS NOT NULL THEN
1781: UPDATE mtl_mwb_gtmp
1782: SET trading_partner_site = (SELECT vendor_site_code
1783: FROM po_vendor_sites_all
1784: WHERE vendor_site_id = l_vendor_site_id)
1785: WHERE vendor_id = l_vendor_id
1786: AND vendor_site_id = l_vendor_site_id;
1787: END IF;

Line 1836: FROM po_vendor_sites_all ps, po_vendors pv

1832: SET planning_party = inv_mwb_globals.g_planning_party;
1833: ELSE
1834: UPDATE mtl_mwb_gtmp
1835: SET planning_party = (SELECT vendor_name || '-' || vendor_site_code
1836: FROM po_vendor_sites_all ps, po_vendors pv
1837: WHERE pv.vendor_id = ps.vendor_id
1838: AND ps.vendor_site_id = rec.planning_organization_id)
1839: WHERE planning_organization_id = rec.planning_organization_id;
1840: END IF;

Line 1852: FROM po_vendor_sites_all ps, po_vendors pv

1848: SET owning_party = inv_mwb_globals.g_owning_party;
1849: ELSE
1850: UPDATE mtl_mwb_gtmp
1851: SET owning_party = (SELECT vendor_name || '-' || vendor_site_code
1852: FROM po_vendor_sites_all ps, po_vendors pv
1853: WHERE pv.vendor_id = ps.vendor_id
1854: AND ps.vendor_site_id = rec.owning_organization_id)
1855: WHERE owning_organization_id = rec.owning_organization_id;
1856: END IF;