APPS.INV_MWB_QUERY_MANAGER dependencies on PO_VENDORS

Line 1775: FROM po_vendors

1771: IF rec.vendor_id IS NOT NULL
1772: OR l_vendor_id IS NOT NULL THEN
1773: UPDATE mtl_mwb_gtmp
1774: SET trading_partner = (SELECT vendor_name
1775: FROM po_vendors
1776: WHERE vendor_id = l_vendor_id)
1777: WHERE vendor_id = l_vendor_id;
1778:
1779: IF rec.vendor_site_id IS NOT NULL

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;