VIEW: APPS.HRI_CL_EDU_QUAL_TYPE_V

Source

View Text - Preformatted

SELECT qut.qualification_type_id ID , qut.name VALUE , qut.category CATEGORY , qut.rank RANK FROM PER_QUALIFICATION_TYPES qut UNION ALL SELECT -1 ID , '' VALUE , to_char(null) CATEGORY , to_number(null) RANK FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT QUT.QUALIFICATION_TYPE_ID ID
, QUT.NAME VALUE
, QUT.CATEGORY CATEGORY
, QUT.RANK RANK
FROM PER_QUALIFICATION_TYPES QUT UNION ALL SELECT -1 ID
, '' VALUE
, TO_CHAR(NULL) CATEGORY
, TO_NUMBER(NULL) RANK
FROM DUAL WITH READ ONLY