VIEW: APPS.POA_SUPPLIER_SITES_V

Source

View Text - Preformatted

SELECT vendor_site_id id, vendor_site_code || ' (' || vendor_name || ' - ' || ou.name||')' value, sites.vendor_id, sites.org_id, sites.creation_date, sites.last_update_date FROM PO_VENDOR_SITES_ALL sites, po_vendors vendor, hr_all_organization_units_tl ou WHERE vendor.vendor_id = sites.vendor_id and ou.organization_id = sites.org_id and ou.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT VENDOR_SITE_ID ID
, VENDOR_SITE_CODE || ' (' || VENDOR_NAME || ' - ' || OU.NAME||')' VALUE
, SITES.VENDOR_ID
, SITES.ORG_ID
, SITES.CREATION_DATE
, SITES.LAST_UPDATE_DATE
FROM PO_VENDOR_SITES_ALL SITES
, PO_VENDORS VENDOR
, HR_ALL_ORGANIZATION_UNITS_TL OU
WHERE VENDOR.VENDOR_ID = SITES.VENDOR_ID
AND OU.ORGANIZATION_ID = SITES.ORG_ID
AND OU.LANGUAGE = USERENV('LANG')