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

TABLE: JTF.JTF_TAE_RPT_OBJ_MATCHES

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


This table stores the matching territories for reports


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_TAE_RPT_MATCHES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
ColumnTRANS_OBJECT_ID
ColumnTRANS_OBJECT_TYPE_ID
ColumnTOP_LEVEL_TERR_ID
ColumnTERR_ID
Columns
Name Datatype Length Mandatory Comments
TRANS_OBJECT_ID NUMBER
Yes Trans Object Identifier
TRANS_DETAIL_OBJECT_ID NUMBER

Trans Detail Object Identifier
HEADER_ID1 NUMBER

Header Identifier1
HEADER_ID2 NUMBER

Header Identifier2
SOURCE_ID NUMBER
Yes Source Identifier
TRANS_OBJECT_TYPE_ID NUMBER
Yes Trans Object Type Identifier
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER

Last Updated By
CREATION_DATE DATE

Creation Date
CREATED_BY NUMBER

Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
REQUEST_ID NUMBER

Request Identifier
PROGRAM_APPLICATION_ID NUMBER

Program Application Identifier
PROGRAM_ID NUMBER

Program Identifier
PROGRAM_UPDATE_DATE DATE

Program Update Date
SESSION_ID NUMBER

Session Identifier
TERR_ID NUMBER

Territory Identifier
ABSOLUTE_RANK NUMBER

Territory Rank
TOP_LEVEL_TERR_ID NUMBER

Top Level Territory Identifier
NUM_WINNERS NUMBER

Number of Winners
ORG_ID NUMBER

Organization Identifier
SECURITY_GROUP_ID NUMBER

Security Group Identifier
OBJECT_VERSION_NUMBER NUMBER

standard column
Query Text

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


SELECT TRANS_OBJECT_ID
,      TRANS_DETAIL_OBJECT_ID
,      HEADER_ID1
,      HEADER_ID2
,      SOURCE_ID
,      TRANS_OBJECT_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SESSION_ID
,      TERR_ID
,      ABSOLUTE_RANK
,      TOP_LEVEL_TERR_ID
,      NUM_WINNERS
,      ORG_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_TAE_RPT_OBJ_MATCHES;

Dependencies

[top of page]

JTF.JTF_TAE_RPT_OBJ_MATCHES does not reference any database object

JTF.JTF_TAE_RPT_OBJ_MATCHES is referenced by following:

SchemaAPPS
SynonymJTF_TAE_RPT_OBJ_MATCHES