DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BNE_PARAM_DEFNS_VL

Object Details
Object Name: BNE_PARAM_DEFNS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBNE.BNE_PARAM_DEFNS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


BNE_PARAM_DEFNS_VL is a standard translation view over the BNE_PARAM_DEFNS entity.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Base table Row ID
APPLICATION_ID NUMBER (15) Yes Entity column. Refer base entity.
PARAM_DEFN_CODE VARCHAR2 (30) Yes Entity column. Refer base entity.
OBJECT_VERSION_NUMBER NUMBER (15) Yes Entity column. Refer base entity.
PARAM_NAME VARCHAR2 (240) Yes Entity column. Refer base entity.
PARAM_SOURCE VARCHAR2 (240) Yes Entity column. Refer base entity.
PARAM_CATEGORY NUMBER (5) Yes Entity column. Refer base entity.
USER_NAME VARCHAR2 (240) Yes Entity column. Refer base entity.
DATATYPE NUMBER (1) Yes Entity column. Refer base entity.
ATTRIBUTE_APP_ID NUMBER (15)
Entity column. Refer base entity.
ATTRIBUTE_CODE VARCHAR2 (30)
Entity column. Refer base entity.
PARAM_RESOLVER VARCHAR2 (240)
Entity column. Refer base entity.
DEFAULT_REQUIRED_FLAG VARCHAR2 (1) Yes Entity column. Refer base entity.
DEFAULT_VISIBLE_FLAG VARCHAR2 (1) Yes Entity column. Refer base entity.
DEFAULT_USER_MODIFYABLE_FLAG VARCHAR2 (1) Yes Entity column. Refer base entity.
DEFAULT_STRING VARCHAR2 (2000)
Entity column. Refer base entity.
DEFAULT_STRING_TRANS_FLAG VARCHAR2 (1)
Entity column. Refer base entity.
DEFAULT_DATE DATE

Entity column. Refer base entity.
DEFAULT_NUMBER NUMBER

Entity column. Refer base entity.
DEFAULT_BOOLEAN_FLAG VARCHAR2 (1)
Entity column. Refer base entity.
DEFAULT_FORMULA VARCHAR2 (240)
Entity column. Refer base entity.
VAL_TYPE VARCHAR2 (2) Yes Entity column. Refer base entity.
VAL_VALUE VARCHAR2 (30)
Entity column. Refer base entity.
MAX_SIZE NUMBER (5) Yes Entity column. Refer base entity.
DISPLAY_TYPE NUMBER (1) Yes Entity column. Refer base entity.
DISPLAY_STYLE NUMBER (1) Yes Entity column. Refer base entity.
DISPLAY_SIZE NUMBER (5) Yes Entity column. Refer base entity.
DEFAULT_DESC VARCHAR2 (240)
Entity column. Refer base entity.
PROMPT_LEFT VARCHAR2 (240)
Entity column. Refer base entity.
PROMPT_ABOVE VARCHAR2 (240)
Entity column. Refer base entity.
USER_TIP VARCHAR2 (2000)
Entity column. Refer base entity.
HELP_URL VARCHAR2 (240)
Entity column. Refer base entity.
FORMAT_MASK VARCHAR2 (240)
Entity column. Refer base entity.
ACCESS_KEY VARCHAR2 (30)
Entity column. Refer base entity.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
OA_FLEX_APPLICATION_ID NUMBER (15)
OA_FLEX_CODE VARCHAR2 (30)
OA_FLEX_NUM VARCHAR2 (2000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      APPLICATION_ID
,      PARAM_DEFN_CODE
,      OBJECT_VERSION_NUMBER
,      PARAM_NAME
,      PARAM_SOURCE
,      PARAM_CATEGORY
,      USER_NAME
,      DATATYPE
,      ATTRIBUTE_APP_ID
,      ATTRIBUTE_CODE
,      PARAM_RESOLVER
,      DEFAULT_REQUIRED_FLAG
,      DEFAULT_VISIBLE_FLAG
,      DEFAULT_USER_MODIFYABLE_FLAG
,      DEFAULT_STRING
,      DEFAULT_STRING_TRANS_FLAG
,      DEFAULT_DATE
,      DEFAULT_NUMBER
,      DEFAULT_BOOLEAN_FLAG
,      DEFAULT_FORMULA
,      VAL_TYPE
,      VAL_VALUE
,      MAX_SIZE
,      DISPLAY_TYPE
,      DISPLAY_STYLE
,      DISPLAY_SIZE
,      DEFAULT_DESC
,      PROMPT_LEFT
,      PROMPT_ABOVE
,      USER_TIP
,      HELP_URL
,      FORMAT_MASK
,      ACCESS_KEY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      OA_FLEX_APPLICATION_ID
,      OA_FLEX_CODE
,      OA_FLEX_NUM
FROM APPS.BNE_PARAM_DEFNS_VL;

Dependencies

[top of page]

APPS.BNE_PARAM_DEFNS_VL references the following:

SchemaAPPS
SynonymBNE_PARAM_DEFNS_B
SynonymBNE_PARAM_DEFNS_TL

APPS.BNE_PARAM_DEFNS_VL is not referenced by any database object