eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PER_PROPOSAL_QUESTION_TYPES#

Source

View Text - Preformatted


select PROPOSAL_QUESTION_NAME PROPOSAL_QUESTION_NAME, FULL_TEXT FULL_TEXT, ALIGN ALIGN, QUESTION_HEADER QUESTION_HEADER, HELP_TEXT HELP_TEXT, NOTE_TEXT NOTE_TEXT, HTML_TYPE HTML_TYPE, WIDTH_SIZE WIDTH_SIZE, HEIGHT_SIZE HEIGHT_SIZE, MAXLENGTH MAXLENGTH, DEFAULT_VALUE_TYPE DEFAULT_VALUE_TYPE, DEFAULT_VALUE DEFAULT_VALUE, LOOKUP_TYPE LOOKUP_TYPE, OPTION_SQL_TEXT OPTION_SQL_TEXT, PROVIDE_FIND PROVIDE_FIND, FIND_FILTER_COLUMN FIND_FILTER_COLUMN, FIND_SELECT_SQL FIND_SELECT_SQL, TYPE TYPE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PER_PROPOSAL_QUESTION_TYPES"

View Text - HTML Formatted

SELECT PROPOSAL_QUESTION_NAME PROPOSAL_QUESTION_NAME
, FULL_TEXT FULL_TEXT
, ALIGN ALIGN
, QUESTION_HEADER QUESTION_HEADER
, HELP_TEXT HELP_TEXT
, NOTE_TEXT NOTE_TEXT
, HTML_TYPE HTML_TYPE
, WIDTH_SIZE WIDTH_SIZE
, HEIGHT_SIZE HEIGHT_SIZE
, MAXLENGTH MAXLENGTH
, DEFAULT_VALUE_TYPE DEFAULT_VALUE_TYPE
, DEFAULT_VALUE DEFAULT_VALUE
, LOOKUP_TYPE LOOKUP_TYPE
, OPTION_SQL_TEXT OPTION_SQL_TEXT
, PROVIDE_FIND PROVIDE_FIND
, FIND_FILTER_COLUMN FIND_FILTER_COLUMN
, FIND_SELECT_SQL FIND_SELECT_SQL
, TYPE TYPE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PER_PROPOSAL_QUESTION_TYPES"