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: FII.FII_FA_CAT_SEGMENTS

Object Details

Object Name:	FII_FA_CAT_SEGMENTS
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_FA_CAT_SEGMENTS
Subobject Name:
Status:	VALID

This table stores the Asset Category flexfield structure information which identifies the setup of the flexfield's major and minor qualified segments.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_FA_CAT_SEGMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FLEX_STRUCTURE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FLEX_STRUCTURE_ID	NUMBER		Yes	Key flexfield structure defining column
MAJOR_SEG_NAME	VARCHAR2	(30)		Column name of the major segment in the flex combination table
MAJOR_VAL_TYPE_CODE	VARCHAR2	(30)		Validation type used by the major segments value set
MAJOR_TABLE_NAME	VARCHAR2	(240)		Table name used for the major segment in table-based value sets
MAJOR_VALUE_COLUMN_NAME	VARCHAR2	(240)		Column name used for the major segment value in table-based value sets
MAJOR_ID_COLUMN_NAME	VARCHAR2	(240)		Column name used for the major segment identifier in table-based value sets
MAJOR_ADD_WHERE_CLAUSE	VARCHAR2	(1000)		The SQL WHERE clause used for the major segment identifier in table-based value sets
MINOR_SEG_NAME	VARCHAR2	(30)		Column name of the minor segment in the flex combination table
MINOR_VAL_TYPE_CODE	VARCHAR2	(30)		Validation type used by the minor segments value set
MINOR_TABLE_NAME	VARCHAR2	(240)		Table name used for the minor segment in table-based value sets
MINOR_VALUE_COLUMN_NAME	VARCHAR2	(240)		Column name used for the minor segment value in table-based value sets
MINOR_ID_COLUMN_NAME	VARCHAR2	(240)		Column name used for the minor segment identifier in table-based value sets
MINOR_ADD_WHERE_CLAUSE	VARCHAR2	(1000)		The SQL WHERE clause used for the minor segment identifier in table-based value sets
DEPENDANT_VALUE_SET_FLAG	VARCHAR2	(1)		Indicates whether the minor segment is dependant on the major segment
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT FLEX_STRUCTURE_ID
,      MAJOR_SEG_NAME
,      MAJOR_VAL_TYPE_CODE
,      MAJOR_TABLE_NAME
,      MAJOR_VALUE_COLUMN_NAME
,      MAJOR_ID_COLUMN_NAME
,      MAJOR_ADD_WHERE_CLAUSE
,      MINOR_SEG_NAME
,      MINOR_VAL_TYPE_CODE
,      MINOR_TABLE_NAME
,      MINOR_VALUE_COLUMN_NAME
,      MINOR_ID_COLUMN_NAME
,      MINOR_ADD_WHERE_CLAUSE
,      DEPENDANT_VALUE_SET_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FII.FII_FA_CAT_SEGMENTS;

Dependencies

[top of page]

FII.FII_FA_CAT_SEGMENTS does not reference any database object

FII.FII_FA_CAT_SEGMENTS is referenced by following:

APPS: FII_FA_CAT_SEGMENTS