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

TABLE: JTF.JTF_TAE_RPT_STAGING_OUT

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


This table stores final output data from which report is rendered


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_TAE_RPT_STAGING_OUT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSION_ID
ColumnTRANS_OBJECT_TYPE_ID
ColumnSOURCE_ID
Columns
Name Datatype Length Mandatory Comments
TRANS_OBJECT_ID NUMBER
Yes Trans Object Identifier
TRANS_DETAIL_OBJECT_ID NUMBER
Yes 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
SESSION_ID NUMBER
Yes Session Identifier
AT_CHAR01 VARCHAR2 (240)
String Attribute
AT_CHAR02 VARCHAR2 (240)
String Attribute
AT_CHAR03 VARCHAR2 (240)
String Attribute
AT_CHAR04 VARCHAR2 (240)
String Attribute
AT_CHAR05 VARCHAR2 (240)
String Attribute
AT_CHAR06 VARCHAR2 (240)
String Attribute
AT_CHAR07 VARCHAR2 (240)
String Attribute
AT_CHAR08 VARCHAR2 (240)
String Attribute
AT_CHAR09 VARCHAR2 (240)
String Attribute
AT_CHAR10 VARCHAR2 (240)
String Attribute
AT_CHAR11 VARCHAR2 (240)
String Attribute
AT_CHAR12 VARCHAR2 (240)
String Attribute
AT_CHAR13 VARCHAR2 (240)
String Attribute
AT_CHAR14 VARCHAR2 (240)
String Attribute
AT_CHAR15 VARCHAR2 (240)
String Attribute
AT_CHAR16 VARCHAR2 (240)
String Attribute
AT_CHAR17 VARCHAR2 (240)
String Attribute
AT_CHAR18 VARCHAR2 (240)
String Attribute
AT_CHAR19 VARCHAR2 (240)
String Attribute
AT_CHAR20 VARCHAR2 (240)
String Attribute
AT_NUM01 NUMBER

Number Attribute
AT_NUM02 NUMBER

Number Attribute
AT_NUM03 NUMBER

Number Attribute
AT_NUM04 NUMBER

Number Attribute
AT_NUM05 NUMBER

Number Attribute
AT_NUM06 NUMBER

Number Attribute
AT_NUM07 NUMBER

Number Attribute
AT_NUM08 NUMBER

Number Attribute
AT_NUM09 NUMBER

Number Attribute
AT_NUM10 NUMBER

Number Attribute
AT_NUM11 NUMBER

Number Attribute
AT_NUM12 NUMBER

Number Attribute
AT_NUM13 NUMBER

Number Attribute
AT_NUM14 NUMBER

Number Attribute
AT_NUM15 NUMBER

Number Attribute
AT_NUM16 NUMBER

Number Attribute
AT_NUM17 NUMBER

Number Attribute
AT_NUM18 NUMBER

Number Attribute
AT_NUM19 NUMBER

Number Attribute
AT_NUM20 NUMBER

Number Attribute
TERR_ID NUMBER
Yes Foreign key to JTF_TERR_ALL table.
TERR_NAME VARCHAR2 (240)
Territory Name
TERR_RANK NUMBER

Territory Rank
RELATED_TERR_ID NUMBER

Foreign key to JTF_TERR_ALL table.
RELATED_TERR_NAME VARCHAR2 (240)
Related Territory Name
RESOURCE_ID NUMBER

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

Part of composite Foreign key to JTF_RESOURCES_V.
RESOURCE_NAME VARCHAR2 (240)
Resource Name
GROUP_ID NUMBER

ID of Group that resource belongs to.
GROUP_NAME VARCHAR2 (240)
Group Name
ROLE VARCHAR2 (240)
Resource Role. eg: Field Service Engineer
ROLE_NAME VARCHAR2 (240)
Role Name
TERR_QUAL_ID NUMBER

ID of Group that resource belongs to.
QUAL_USG_ID NUMBER

ID of Group that resource belongs to.
QUALIFIER_NAME VARCHAR2 (240)
Qualifier Name
TERR_VALUE_ID NUMBER

Territory Value Unique Identifier
LOW_VALUE_CHAR VARCHAR2 (240)
The low value character for this qualifier.
HIGH_VALUE_CHAR VARCHAR2 (240)
The high value character for this qualifier.
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
,      SESSION_ID
,      AT_CHAR01
,      AT_CHAR02
,      AT_CHAR03
,      AT_CHAR04
,      AT_CHAR05
,      AT_CHAR06
,      AT_CHAR07
,      AT_CHAR08
,      AT_CHAR09
,      AT_CHAR10
,      AT_CHAR11
,      AT_CHAR12
,      AT_CHAR13
,      AT_CHAR14
,      AT_CHAR15
,      AT_CHAR16
,      AT_CHAR17
,      AT_CHAR18
,      AT_CHAR19
,      AT_CHAR20
,      AT_NUM01
,      AT_NUM02
,      AT_NUM03
,      AT_NUM04
,      AT_NUM05
,      AT_NUM06
,      AT_NUM07
,      AT_NUM08
,      AT_NUM09
,      AT_NUM10
,      AT_NUM11
,      AT_NUM12
,      AT_NUM13
,      AT_NUM14
,      AT_NUM15
,      AT_NUM16
,      AT_NUM17
,      AT_NUM18
,      AT_NUM19
,      AT_NUM20
,      TERR_ID
,      TERR_NAME
,      TERR_RANK
,      RELATED_TERR_ID
,      RELATED_TERR_NAME
,      RESOURCE_ID
,      RESOURCE_TYPE
,      PERSON_ID
,      RESOURCE_NAME
,      GROUP_ID
,      GROUP_NAME
,      ROLE
,      ROLE_NAME
,      TERR_QUAL_ID
,      QUAL_USG_ID
,      QUALIFIER_NAME
,      TERR_VALUE_ID
,      LOW_VALUE_CHAR
,      HIGH_VALUE_CHAR
,      ORG_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_TAE_RPT_STAGING_OUT;

Dependencies

[top of page]

JTF.JTF_TAE_RPT_STAGING_OUT does not reference any database object

JTF.JTF_TAE_RPT_STAGING_OUT is referenced by following:

SchemaAPPS
SynonymJTF_TAE_RPT_STAGING_OUT
Package BodyJTF_TERR_RPT - show dependent code