VIEW: APPS.HRI_CL_EDU_ESTBMNT_V

Source

View Text - Preformatted

SELECT est.establishment_id ID ,est.name VALUE FROM per_establishments est UNION ALL SELECT -1 ID ,'' VALUE FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT EST.ESTABLISHMENT_ID ID
, EST.NAME VALUE
FROM PER_ESTABLISHMENTS EST UNION ALL SELECT -1 ID
, '' VALUE
FROM DUAL WITH READ ONLY