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_ASSIGNMENTS

Object Details

Object Name:	FND_FLEXBUILDER_ASSIGNMENTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_FLEXBUILDER_ASSIGNMENTS
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_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	APPLICATION_ID FUNCTION_CODE ID_FLEX_NUM SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(10)	Yes	Application identifier
FUNCTION_CODE	VARCHAR2	(30)	Yes	Flexbuilder function code
ID_FLEX_NUM	NUMBER	(10)	Yes	Key flexfield structure number
SEQUENCE	NUMBER	(3)	Yes	Sequence number for the assignment
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)		Standard Who column
ASSIGNMENT_TYPE	VARCHAR2	(1)	Yes	Type of assignment
PROTECTED_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether this is a protected assignment
DESCRIPTION	VARCHAR2	(250)		Description
CONDITIONAL_PARAMETER	VARCHAR2	(30)		Flexbuilder parameter name for conditional assignment
CONDITIONAL_VALUE	VARCHAR2	(250)		Value of conditional parameter
ID_PARAMETER	VARCHAR2	(30)		"Flexfield" type flexbuilder parameter
FLEXFIELD_SEGMENT_USAGES	VARCHAR2	(250)		Segment usage information for the "Flexfield" type assignments
SEGMENT_ATTRIBUTE_TYPE	VARCHAR2	(30)		Flexfield qualifier
SEGMENT_PARAMETER_PAIRINGS	VARCHAR2	(240)		Pairings of flexfield segments and flexbuilder parameters
SEGMENT_PARAMETER	VARCHAR2	(30)		Flexbuilder parameter to obtain segment value for segments identified by the flexfield qualifier
SEGMENT_CONSTANTS	VARCHAR2	(2000)		Constant values for flexfield segments

Query Text

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


SELECT APPLICATION_ID
,      FUNCTION_CODE
,      ID_FLEX_NUM
,      SEQUENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ASSIGNMENT_TYPE
,      PROTECTED_FLAG
,      DESCRIPTION
,      CONDITIONAL_PARAMETER
,      CONDITIONAL_VALUE
,      ID_PARAMETER
,      FLEXFIELD_SEGMENT_USAGES
,      SEGMENT_ATTRIBUTE_TYPE
,      SEGMENT_PARAMETER_PAIRINGS
,      SEGMENT_PARAMETER
,      SEGMENT_CONSTANTS
FROM APPLSYS.FND_FLEXBUILDER_ASSIGNMENTS;

Dependencies

[top of page]

APPLSYS.FND_FLEXBUILDER_ASSIGNMENTS does not reference any database object

APPLSYS.FND_FLEXBUILDER_ASSIGNMENTS is referenced by following:

APPLSYS: FND_FLEXBUILDER_ASSIGNMENTS#