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

TABLE: JTF.JTY_DEA_ATTR_FACTORS

Object Details
Object Name: JTY_DEA_ATTR_FACTORS
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTY_DEA_ATTR_FACTORS
Subobject Name:
Status: VALID


This table stores attribute factors for date effectivity assignment.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DEA_ATTR_FACTORS_ID NUMBER
Yes Primary key
QUAL_USG_ID NUMBER
Yes Foreign key to JTF_QUAL_USGS_ALL
RELATION_FACTOR NUMBER
Yes Relation factor
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
TERR_ANALYZE_ID NUMBER

Territory analyze ID
TAE_COL_MAP VARCHAR2 (30)
TAE column map
TAE_REC_MAP VARCHAR2 (30)
TAE record map
USE_TAE_COL_IN_INDEX_FLAG VARCHAR2 (1)
Use TAE column in index flag
UPDATE_SELECTIVITY_FLAG VARCHAR2 (1)
Update selectivity flag
INPUT_SELECTIVITY NUMBER

Input selectivity
INPUT_ORDINAL_SELECTIVITY NUMBER

Input ordinal selectivity
INPUT_DEVIATION NUMBER

Input deviation
SECURITY_GROUP_ID NUMBER

used in hosted environment
OBJECT_VERSION_NUMBER NUMBER

Object version number
Query Text

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


SELECT DEA_ATTR_FACTORS_ID
,      QUAL_USG_ID
,      RELATION_FACTOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TERR_ANALYZE_ID
,      TAE_COL_MAP
,      TAE_REC_MAP
,      USE_TAE_COL_IN_INDEX_FLAG
,      UPDATE_SELECTIVITY_FLAG
,      INPUT_SELECTIVITY
,      INPUT_ORDINAL_SELECTIVITY
,      INPUT_DEVIATION
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTY_DEA_ATTR_FACTORS;

Dependencies

[top of page]

JTF.JTY_DEA_ATTR_FACTORS does not reference any database object

JTF.JTY_DEA_ATTR_FACTORS is referenced by following:

SchemaAPPS
SynonymJTY_DEA_ATTR_FACTORS