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

TABLE: JTF.JTY_TERR_VALUES_IDX_DETAILS

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


This table stores indexes for territory values.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTY_TERR_VALUES_IDX_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTERR_VALUES_IDX_HEADER_ID
JTY_TERR_VALUES_IDX_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVALUES_COL_MAP
Columns
Name Datatype Length Mandatory Comments
TERR_VALUES_IDX_DETAILS_ID NUMBER
Yes Primary key
TERR_VALUES_IDX_HEADER_ID NUMBER
Yes Foreign key to JTY_TERR_VALUES_IDX_HEADER
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
VALUES_COL_MAP VARCHAR2 (30)
Values column map
INPUT_SELECTIVITY NUMBER

Input selectivity
INPUT_ORDINAL_SELECTIVITY NUMBER

Input ordinal selectivity
SECURITY_GROUP_ID NUMBER

used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

Object version number
Query Text

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


SELECT TERR_VALUES_IDX_DETAILS_ID
,      TERR_VALUES_IDX_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      VALUES_COL_MAP
,      INPUT_SELECTIVITY
,      INPUT_ORDINAL_SELECTIVITY
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTY_TERR_VALUES_IDX_DETAILS;

Dependencies

[top of page]

JTF.JTY_TERR_VALUES_IDX_DETAILS does not reference any database object

JTF.JTY_TERR_VALUES_IDX_DETAILS is referenced by following:

SchemaAPPS
SynonymJTY_TERR_VALUES_IDX_DETAILS