VIEW: APPS.POA_OBIEE_SUPPLIER_SITES_V

Source

View Text - Preformatted

SELECT vendor_site_id id, vendor_site_code || ' (' || vendor_name || ' - ' || ou.name||')' value, sites.vendor_id vendor_id, sites.org_id org_id, sites.creation_date creation_date, sites.last_update_date 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') union all ( select -1 vendor_site_id, fnd_message.get_string('POA','POA_DBI_APL_UNASSIGNED') value, -1 vendor_id, -1 org_id, sysdate creation_date, sysdate last_update_date from dual )

View Text - HTML Formatted

SELECT VENDOR_SITE_ID ID
, VENDOR_SITE_CODE || ' (' || VENDOR_NAME || ' - ' || OU.NAME||')' VALUE
, SITES.VENDOR_ID VENDOR_ID
, SITES.ORG_ID ORG_ID
, SITES.CREATION_DATE CREATION_DATE
, SITES.LAST_UPDATE_DATE 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') UNION ALL ( SELECT -1 VENDOR_SITE_ID
, FND_MESSAGE.GET_STRING('POA'
, 'POA_DBI_APL_UNASSIGNED') VALUE
, -1 VENDOR_ID
, -1 ORG_ID
, SYSDATE CREATION_DATE
, SYSDATE LAST_UPDATE_DATE
FROM DUAL )