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

TABLE: JTF.JTF_TAE_RPT_OBJ_WINNERS

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


This table stores winning territories


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RESULT_ID NUMBER

Result Identifier
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 Identifer
PROGRAM_ID NUMBER

Program Identifer
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
TERR_RSC_ID NUMBER

Territory Resource Identifier
RESOURCE_ID NUMBER

Resource Identifier
RESOURCE_TYPE VARCHAR2 (240)
Resource Type - part of composite Foreign key to JTF_RESOURCES_V.
GROUP_ID NUMBER

ID of Group that resource belongs to.
ROLE VARCHAR2 (240)
Resource Role. eg: Field Service Engineer
PRIMARY_CONTACT_FLAG VARCHAR2 (1)
Flag to indicate Primary Contact
FULL_ACCESS_FLAG VARCHAR2 (3)
Flag to indicate Full Access
PERSON_ID NUMBER

Person Identifier
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 RESULT_ID
,      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
,      TERR_RSC_ID
,      RESOURCE_ID
,      RESOURCE_TYPE
,      GROUP_ID
,      ROLE
,      PRIMARY_CONTACT_FLAG
,      FULL_ACCESS_FLAG
,      PERSON_ID
,      ORG_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_TAE_RPT_OBJ_WINNERS;

Dependencies

[top of page]

JTF.JTF_TAE_RPT_OBJ_WINNERS does not reference any database object

JTF.JTF_TAE_RPT_OBJ_WINNERS is referenced by following:

SchemaJTF
ViewJTF_TAE_RPT_OBJ_WINNERS#