View: BNE_PARAM_DEFNS_VL

Product:	BNE - Web Applications Desktop Integrator
Description:	BNE_PARAM_DEFNS_VL is a standard translation view over the BNE_PARAM_DEFNS entity.
Implementation/DBA Data:	APPS.BNE_PARAM_DEFNS_VL

View Text

SELECT D.ROWID ROW_ID
, D.APPLICATION_ID
, D.PARAM_DEFN_CODE
, D.OBJECT_VERSION_NUMBER
, D.PARAM_NAME
, D.PARAM_SOURCE
, D.PARAM_CATEGORY
, T.USER_NAME
, D.DATATYPE
, D.ATTRIBUTE_APP_ID
, D.ATTRIBUTE_CODE
, D.PARAM_RESOLVER
, D.DEFAULT_REQUIRED_FLAG
, D.DEFAULT_VISIBLE_FLAG
, D.DEFAULT_USER_MODIFYABLE_FLAG
, NVL(T.DEFAULT_STRING
, D.DEFAULT_STRING)
, DECODE(T.DEFAULT_STRING
, NULL
, 'N'
, 'Y')
, D.DEFAULT_DATE
, D.DEFAULT_NUMBER
, D.DEFAULT_BOOLEAN_FLAG
, D.DEFAULT_FORMULA
, D.VAL_TYPE
, D.VAL_VALUE
, D.MAX_SIZE
, D.DISPLAY_TYPE
, D.DISPLAY_STYLE
, D.DISPLAY_SIZE
, T.DEFAULT_DESC
, T.PROMPT_LEFT
, T.PROMPT_ABOVE
, T.USER_TIP
, D.HELP_URL
, D.FORMAT_MASK
, T.ACCESS_KEY
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.LAST_UPDATE_DATE
, D.OA_FLEX_APPLICATION_ID
, D.OA_FLEX_CODE
, D.OA_FLEX_NUM
FROM BNE_PARAM_DEFNS_B D
, BNE_PARAM_DEFNS_TL T WHERE D.APPLICATION_ID = T.APPLICATION_ID
AND D.PARAM_DEFN_CODE = T.PARAM_DEFN_CODE AND T.LANGUAGE = USERENV ('LANG')

Columns