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: BNE.BNE_PARAM_DEFNS_B#

Source

View Text - Preformatted


select APPLICATION_ID APPLICATION_ID, PARAM_DEFN_CODE PARAM_DEFN_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PARAM_NAME PARAM_NAME, PARAM_SOURCE PARAM_SOURCE, PARAM_CATEGORY PARAM_CATEGORY, DATATYPE DATATYPE, ATTRIBUTE_APP_ID ATTRIBUTE_APP_ID, ATTRIBUTE_CODE ATTRIBUTE_CODE, PARAM_RESOLVER PARAM_RESOLVER, DEFAULT_REQUIRED_FLAG DEFAULT_REQUIRED_FLAG, DEFAULT_VISIBLE_FLAG DEFAULT_VISIBLE_FLAG, DEFAULT_USER_MODIFYABLE_FLAG DEFAULT_USER_MODIFYABLE_FLAG, DEFAULT_STRING DEFAULT_STRING, DEFAULT_DATE DEFAULT_DATE, DEFAULT_NUMBER DEFAULT_NUMBER, DEFAULT_BOOLEAN_FLAG DEFAULT_BOOLEAN_FLAG, DEFAULT_FORMULA DEFAULT_FORMULA, VAL_TYPE VAL_TYPE, VAL_VALUE VAL_VALUE, MAX_SIZE MAX_SIZE, DISPLAY_TYPE DISPLAY_TYPE, DISPLAY_STYLE DISPLAY_STYLE, DISPLAY_SIZE DISPLAY_SIZE, HELP_URL HELP_URL, FORMAT_MASK FORMAT_MASK, 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, OA_FLEX_APPLICATION_ID OA_FLEX_APPLICATION_ID, OA_FLEX_CODE OA_FLEX_CODE, OA_FLEX_NUM OA_FLEX_NUM, ZD_EDITION_NAME ZD_EDITION_NAME from "BNE"."BNE_PARAM_DEFNS_B"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, PARAM_DEFN_CODE PARAM_DEFN_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PARAM_NAME PARAM_NAME
, PARAM_SOURCE PARAM_SOURCE
, PARAM_CATEGORY PARAM_CATEGORY
, DATATYPE DATATYPE
, ATTRIBUTE_APP_ID ATTRIBUTE_APP_ID
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, PARAM_RESOLVER PARAM_RESOLVER
, DEFAULT_REQUIRED_FLAG DEFAULT_REQUIRED_FLAG
, DEFAULT_VISIBLE_FLAG DEFAULT_VISIBLE_FLAG
, DEFAULT_USER_MODIFYABLE_FLAG DEFAULT_USER_MODIFYABLE_FLAG
, DEFAULT_STRING DEFAULT_STRING
, DEFAULT_DATE DEFAULT_DATE
, DEFAULT_NUMBER DEFAULT_NUMBER
, DEFAULT_BOOLEAN_FLAG DEFAULT_BOOLEAN_FLAG
, DEFAULT_FORMULA DEFAULT_FORMULA
, VAL_TYPE VAL_TYPE
, VAL_VALUE VAL_VALUE
, MAX_SIZE MAX_SIZE
, DISPLAY_TYPE DISPLAY_TYPE
, DISPLAY_STYLE DISPLAY_STYLE
, DISPLAY_SIZE DISPLAY_SIZE
, HELP_URL HELP_URL
, FORMAT_MASK FORMAT_MASK
, 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
, OA_FLEX_APPLICATION_ID OA_FLEX_APPLICATION_ID
, OA_FLEX_CODE OA_FLEX_CODE
, OA_FLEX_NUM OA_FLEX_NUM
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "BNE"."BNE_PARAM_DEFNS_B"