VIEW: APPS.POA_OBIEE_SUPPLIERS_V

Source

View Text - Preformatted

SELECT vendor_id id, vendor_name value, creation_date, last_update_date from po_vendors union all ( select -1 id, fnd_message.get_string('POA','POA_DBI_APL_UNASSIGNED') value, sysdate creation_date, sysdate last_update_date from dual)

View Text - HTML Formatted

SELECT VENDOR_ID ID
, VENDOR_NAME VALUE
, CREATION_DATE
, LAST_UPDATE_DATE
FROM PO_VENDORS UNION ALL ( SELECT -1 ID
, FND_MESSAGE.GET_STRING('POA'
, 'POA_DBI_APL_UNASSIGNED') VALUE
, SYSDATE CREATION_DATE
, SYSDATE LAST_UPDATE_DATE
FROM DUAL)