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.

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

VIEW: APPS.FND_FLEXBUILDER_PARAMS_VL

Object Details

Object Name:	FND_FLEXBUILDER_PARAMS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_FLEXBUILDER_PARAMS_VL
Subobject Name:
Status:	VALID

View Type

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

FND_FLEXBUILDER_PARAMS_VL is a view that joins the translated,
language specific values from FND_FLEXBUILDER_PARAMS_TL with the
non-displayed data from FND_FLEXBUILDER_PARAMS to form complete
Flexbuilder parameter entities. Oracle Application Object Library
uses this view to display information in languages installed at
your site.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
FLEXFIELD_APPLICATION_ID	NUMBER	(10)		identifier of the application with which the flexfield is registered
FLEX_VALUE_SET_ID	NUMBER	(10)		Flexfield value set identifier
ASSIGNMENT_VALUE_SET_ID	NUMBER	(10)		Assignment value set identifier
VALUE_SET_MATCH_REQUIRED_FLAG	VARCHAR2	(1)		Flag to indicate whether a match in the value set is required
ID_FLEX_CODE	VARCHAR2	(4)		Key flexfield code
ID_FLEX_NUM	NUMBER	(10)		Key flexfield number
ID_PARAMETER	VARCHAR2	(30)		Source parameter for identifying a code combination
OUTPUT_COLUMN	VARCHAR2	(30)		Output column of the value set
SOURCE_PARAMETER	VARCHAR2	(30)		Source parameter to identify a value in the value set
APPLICATION_ID	NUMBER	(10)	Yes	Application identifier
FUNCTION_CODE	VARCHAR2	(30)	Yes	Flexbuilder function code
SEQUENCE	NUMBER	(3)	Yes	The sequence in which the parameter is to be derived
PARAMETER_NAME	VARCHAR2	(30)	Yes	Parameter name
USER_PARAMETER_NAME	VARCHAR2	(80)	Yes	The descriptive title of the parameter
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
ASSIGNMENT_TYPE	VARCHAR2	(1)	Yes	Type of assignment
PARAMETER_TYPE	VARCHAR2	(1)	Yes	Type of parameter
PROTECTED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the flexbuilder parameter is protected against update
DESCRIPTION	VARCHAR2	(250)		Description
APPLICATION_COLUMN_NAME	VARCHAR2	(30)		Column name
SEGMENT_ATTRIBUTE_TYPE	VARCHAR2	(30)		Flexfield identifier for identifying segments in the flexfield
CONDITIONAL_PARAMETER	VARCHAR2	(30)		Parameter name used to conditionally derive the value of the parameter
CONDITIONAL_VALUE	VARCHAR2	(250)		Value of the conditional parameter
CONSTANT_VALUE	VARCHAR2	(250)		Constant value for the parameter

Query Text

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


SELECT ROW_ID
,      FLEXFIELD_APPLICATION_ID
,      FLEX_VALUE_SET_ID
,      ASSIGNMENT_VALUE_SET_ID
,      VALUE_SET_MATCH_REQUIRED_FLAG
,      ID_FLEX_CODE
,      ID_FLEX_NUM
,      ID_PARAMETER
,      OUTPUT_COLUMN
,      SOURCE_PARAMETER
,      APPLICATION_ID
,      FUNCTION_CODE
,      SEQUENCE
,      PARAMETER_NAME
,      USER_PARAMETER_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ASSIGNMENT_TYPE
,      PARAMETER_TYPE
,      PROTECTED_FLAG
,      DESCRIPTION
,      APPLICATION_COLUMN_NAME
,      SEGMENT_ATTRIBUTE_TYPE
,      CONDITIONAL_PARAMETER
,      CONDITIONAL_VALUE
,      CONSTANT_VALUE
FROM APPS.FND_FLEXBUILDER_PARAMS_VL;

Dependencies

[top of page]

APPS.FND_FLEXBUILDER_PARAMS_VL references the following:

APPS: FND_FLEXBUILDER_PARAMETERS; FND_FLEXBUILDER_PARAMS_TL

APPS.FND_FLEXBUILDER_PARAMS_VL is not referenced by any database object