VIEW: AMS.AMS_CPAG_QUESTIONS_B#

Source

View Text - Preformatted

select ACTIVE_STATUS ACTIVE_STATUS, QUESTION_ID QUESTION_ID, QUESTION_TYPE QUESTION_TYPE, CONTENT_ITEM_ID CONTENT_ITEM_ID, HTML_PARAM_NAME HTML_PARAM_NAME, MANDATORY_FLAG MANDATORY_FLAG, WEIGHT_DIM_ID WEIGHT_DIM_ID, DISPLAY_FIELD_TYPE DISPLAY_FIELD_TYPE, DISPLAY_SEQUENCE_NO DISPLAY_SEQUENCE_NO, CUSTOM_JAVASCRIPT_CODE CUSTOM_JAVASCRIPT_CODE, PROFILE_FIELD_ID PROFILE_FIELD_ID, ANSWER_TYPE ANSWER_TYPE, ANSWER_LOOKUP_TYPE ANSWER_LOOKUP_TYPE, ANSWER_LOOKUP_VIEW_NAME ANSWER_LOOKUP_VIEW_NAME, KNOWN_ANSWER_ACTION KNOWN_ANSWER_ACTION, INITIAL_VALUE_TYPE INITIAL_VALUE_TYPE, INITIAL_VALUE_FIELD_ID INITIAL_VALUE_FIELD_ID, INITIAL_VALUE_QUESTION_ID INITIAL_VALUE_QUESTION_ID, MULTILINE_FLAG MULTILINE_FLAG, INPUT_MASK INPUT_MASK, CHAR_WIDTH CHAR_WIDTH, MAX_CHARS MAX_CHARS, HEIGHT HEIGHT, LAYOUT LAYOUT, NO_OF_COLUMNS NO_OF_COLUMNS, MIN_ANSWERS MIN_ANSWERS, MAX_ANSWERS MAX_ANSWERS, SHOW_TIME_FIELD SHOW_TIME_FIELD, TIME_FORMAT TIME_FORMAT, TIMEZONE_ID TIMEZONE_ID, FILE_UPLOAD_BUTTON_TYPE FILE_UPLOAD_BUTTON_TYPE, FILE_UPLOAD_BUTTON_IMAGE FILE_UPLOAD_BUTTON_IMAGE, FILE_UPLOAD_EXTENSIONS FILE_UPLOAD_EXTENSIONS, FILE_UPLOAD_FIELD_WIDTH FILE_UPLOAD_FIELD_WIDTH, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "AMS"."AMS_CPAG_QUESTIONS_B"

View Text - HTML Formatted

SELECT ACTIVE_STATUS ACTIVE_STATUS
, QUESTION_ID QUESTION_ID
, QUESTION_TYPE QUESTION_TYPE
, CONTENT_ITEM_ID CONTENT_ITEM_ID
, HTML_PARAM_NAME HTML_PARAM_NAME
, MANDATORY_FLAG MANDATORY_FLAG
, WEIGHT_DIM_ID WEIGHT_DIM_ID
, DISPLAY_FIELD_TYPE DISPLAY_FIELD_TYPE
, DISPLAY_SEQUENCE_NO DISPLAY_SEQUENCE_NO
, CUSTOM_JAVASCRIPT_CODE CUSTOM_JAVASCRIPT_CODE
, PROFILE_FIELD_ID PROFILE_FIELD_ID
, ANSWER_TYPE ANSWER_TYPE
, ANSWER_LOOKUP_TYPE ANSWER_LOOKUP_TYPE
, ANSWER_LOOKUP_VIEW_NAME ANSWER_LOOKUP_VIEW_NAME
, KNOWN_ANSWER_ACTION KNOWN_ANSWER_ACTION
, INITIAL_VALUE_TYPE INITIAL_VALUE_TYPE
, INITIAL_VALUE_FIELD_ID INITIAL_VALUE_FIELD_ID
, INITIAL_VALUE_QUESTION_ID INITIAL_VALUE_QUESTION_ID
, MULTILINE_FLAG MULTILINE_FLAG
, INPUT_MASK INPUT_MASK
, CHAR_WIDTH CHAR_WIDTH
, MAX_CHARS MAX_CHARS
, HEIGHT HEIGHT
, LAYOUT LAYOUT
, NO_OF_COLUMNS NO_OF_COLUMNS
, MIN_ANSWERS MIN_ANSWERS
, MAX_ANSWERS MAX_ANSWERS
, SHOW_TIME_FIELD SHOW_TIME_FIELD
, TIME_FORMAT TIME_FORMAT
, TIMEZONE_ID TIMEZONE_ID
, FILE_UPLOAD_BUTTON_TYPE FILE_UPLOAD_BUTTON_TYPE
, FILE_UPLOAD_BUTTON_IMAGE FILE_UPLOAD_BUTTON_IMAGE
, FILE_UPLOAD_EXTENSIONS FILE_UPLOAD_EXTENSIONS
, FILE_UPLOAD_FIELD_WIDTH FILE_UPLOAD_FIELD_WIDTH
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "AMS"."AMS_CPAG_QUESTIONS_B"