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]

TABLE: APPLSYS.FND_FLEXBUILDER_PARAMETERS

Object Details

Object Name:	FND_FLEXBUILDER_PARAMETERS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_FLEXBUILDER_PARAMETERS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_FLEXBUILDER_PARAMETERS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	APPLICATION_ID FUNCTION_CODE PARAMETER_NAME SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
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
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 this 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
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)		DECODE(parameter_type, 'D', 'Y', NULL)
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

Query Text

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


SELECT APPLICATION_ID
,      FUNCTION_CODE
,      SEQUENCE
,      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
,      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
FROM APPLSYS.FND_FLEXBUILDER_PARAMETERS;

Dependencies

[top of page]

APPLSYS.FND_FLEXBUILDER_PARAMETERS does not reference any database object

APPLSYS.FND_FLEXBUILDER_PARAMETERS is referenced by following:

APPS: FND_FLEXBUILDER_PARAMETERS