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


TABLE: FTE.FTE_SEL_ATTRIBUTES_TMP

Object Details
Object Name: FTE_SEL_ATTRIBUTES_TMP
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_SEL_ATTRIBUTES_TMP
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: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_SEL_ATTRIBUTES_TMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnQUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Identifier that groups all attributes in the temp table that are used for a query execution
ATTRIBUTE_CODE VARCHAR2 (30)
Caode of the attribute to be used in the query execution
ATTRIBUTE_VALUE VARCHAR2 (240)
character value of the query attribute
ATTRIBUTE_VALUE_NUMBER NUMBER

numeric value of the query attribute
Query Text

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


SELECT QUERY_ID
,      ATTRIBUTE_CODE
,      ATTRIBUTE_VALUE
,      ATTRIBUTE_VALUE_NUMBER
FROM FTE.FTE_SEL_ATTRIBUTES_TMP;

Dependencies

[top of page]

FTE.FTE_SEL_ATTRIBUTES_TMP does not reference any database object

FTE.FTE_SEL_ATTRIBUTES_TMP is referenced by following:

SchemaAPPS
SynonymFTE_SEL_ATTRIBUTES_TMP