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

TABLE: JTF.JTF_TAE_RPT_OBJS

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


This table stores the input data for the BULK TAE.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_TAE_RPT_KEYWORD_EQL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSQUAL_FC01
ColumnSQUAL_CHAR01
ColumnSQUAL_CHAR06
ColumnSQUAL_CHAR07
ColumnREQUEST_ID
JTF_TAE_RPT_KEYWORD_LK_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSQUAL_CHAR01
ColumnSQUAL_CHAR06
ColumnSQUAL_CHAR07
ColumnREQUEST_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
Yes Session Identifier
SQUAL_FC01 VARCHAR2 (3)
Qualifier
SQUAL_FC02 VARCHAR2 (3)
Qualifier
SQUAL_FC03 VARCHAR2 (3)
Qualifier
SQUAL_FC04 VARCHAR2 (3)
Qualifier
SQUAL_FC05 VARCHAR2 (3)
Qualifier
SQUAL_CURC01 VARCHAR2 (30)
Qualifier
SQUAL_CURC02 VARCHAR2 (30)
Qualifier
SQUAL_CURC03 VARCHAR2 (30)
Qualifier
SQUAL_CURC04 VARCHAR2 (30)
Qualifier
SQUAL_CURC05 VARCHAR2 (30)
Qualifier
SQUAL_CURC06 VARCHAR2 (30)
Qualifier
SQUAL_CURC07 VARCHAR2 (30)
Qualifier
SQUAL_CURC08 VARCHAR2 (30)
Qualifier
SQUAL_CURC09 VARCHAR2 (30)
Qualifier
SQUAL_CURC10 VARCHAR2 (30)
Qualifier
SQUAL_CHAR01 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR02 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR03 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR04 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR05 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR06 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR07 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR08 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR09 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR10 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR11 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR12 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR13 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR14 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR15 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR16 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR17 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR18 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR19 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR20 VARCHAR2 (240)
String Qualifier
SQUAL_CHAR21 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR22 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR23 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR24 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR25 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR26 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR27 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR28 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR30 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR31 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR32 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR33 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR34 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR35 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR36 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR37 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR38 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR39 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR40 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR41 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR42 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR43 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR44 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR45 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR46 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR47 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR48 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR49 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR50 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR51 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR52 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR53 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR54 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR55 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR56 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR57 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR58 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR59 VARCHAR2 (360)
String Qualifier
SQUAL_CHAR60 VARCHAR2 (360)
String Qualifier
SQUAL_NUM01 NUMBER

Number Qualifier
SQUAL_NUM02 NUMBER

Number Qualifier
SQUAL_NUM03 NUMBER

Number Qualifier
SQUAL_NUM04 NUMBER

Number Qualifier
SQUAL_NUM05 NUMBER

Number Qualifier
SQUAL_NUM06 NUMBER

Number Qualifier
SQUAL_NUM07 NUMBER

Number Qualifier
SQUAL_NUM08 NUMBER

Number Qualifier
SQUAL_NUM09 NUMBER

Number Qualifier
SQUAL_NUM10 NUMBER

Number Qualifier
SQUAL_NUM11 NUMBER

Number Qualifier
SQUAL_NUM12 NUMBER

Number Qualifier
SQUAL_NUM13 NUMBER

Number Qualifier
SQUAL_NUM14 NUMBER

Number Qualifier
SQUAL_NUM15 NUMBER

Number Qualifier
SQUAL_NUM16 NUMBER

Number Qualifier
SQUAL_NUM17 NUMBER

Number Qualifier
SQUAL_NUM18 NUMBER

Number Qualifier
SQUAL_NUM19 NUMBER

Number Qualifier
SQUAL_NUM20 NUMBER

Number Qualifier
SQUAL_NUM21 NUMBER

Number Qualifier
SQUAL_NUM22 NUMBER

Number Qualifier
SQUAL_NUM23 NUMBER

Number Qualifier
SQUAL_NUM24 NUMBER

Number Qualifier
SQUAL_NUM25 NUMBER

Number Qualifier
SQUAL_NUM26 NUMBER

Number Qualifier
SQUAL_NUM27 NUMBER

Number Qualifier
SQUAL_NUM28 NUMBER

Number Qualifier
SQUAL_NUM29 NUMBER

Number Qualifier
SQUAL_NUM30 NUMBER

Number Qualifier
SQUAL_NUM31 NUMBER

Number Qualifier
SQUAL_NUM32 NUMBER

Number Qualifier
SQUAL_NUM33 NUMBER

Number Qualifier
SQUAL_NUM34 NUMBER

Number Qualifier
SQUAL_NUM35 NUMBER

Number Qualifier
SQUAL_NUM36 NUMBER

Number Qualifier
SQUAL_NUM37 NUMBER

Number Qualifier
SQUAL_NUM38 NUMBER

Number Qualifier
SQUAL_NUM39 NUMBER

Number Qualifier
SQUAL_NUM40 NUMBER

Number Qualifier
SQUAL_NUM41 NUMBER

Number Qualifier
SQUAL_NUM42 NUMBER

Number Qualifier
SQUAL_NUM43 NUMBER

Number Qualifier
SQUAL_NUM44 NUMBER

Number Qualifier
SQUAL_NUM45 NUMBER

Number Qualifier
SQUAL_NUM46 NUMBER

Number Qualifier
SQUAL_NUM47 NUMBER

Number Qualifier
SQUAL_NUM48 NUMBER

Number Qualifier
SQUAL_NUM49 NUMBER

Number Qualifier
SQUAL_NUM50 NUMBER

Number Qualifier
SQUAL_NUM51 NUMBER

Number Qualifier
SQUAL_NUM52 NUMBER

Number Qualifier
SQUAL_NUM53 NUMBER

Number Qualifier
SQUAL_NUM54 NUMBER

Number Qualifier
SQUAL_NUM55 NUMBER

Number Qualifier
SQUAL_NUM56 NUMBER

Number Qualifier
SQUAL_NUM57 NUMBER

Number Qualifier
SQUAL_NUM58 NUMBER

Number Qualifier
SQUAL_NUM59 NUMBER

Number Qualifier
SQUAL_NUM60 NUMBER

Number Qualifier
ASSIGNED_FLAG VARCHAR2 (3)
Assigned Flag
PROCESSED_FLAG VARCHAR2 (3)
Processed Flag
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
,      SQUAL_FC01
,      SQUAL_FC02
,      SQUAL_FC03
,      SQUAL_FC04
,      SQUAL_FC05
,      SQUAL_CURC01
,      SQUAL_CURC02
,      SQUAL_CURC03
,      SQUAL_CURC04
,      SQUAL_CURC05
,      SQUAL_CURC06
,      SQUAL_CURC07
,      SQUAL_CURC08
,      SQUAL_CURC09
,      SQUAL_CURC10
,      SQUAL_CHAR01
,      SQUAL_CHAR02
,      SQUAL_CHAR03
,      SQUAL_CHAR04
,      SQUAL_CHAR05
,      SQUAL_CHAR06
,      SQUAL_CHAR07
,      SQUAL_CHAR08
,      SQUAL_CHAR09
,      SQUAL_CHAR10
,      SQUAL_CHAR11
,      SQUAL_CHAR12
,      SQUAL_CHAR13
,      SQUAL_CHAR14
,      SQUAL_CHAR15
,      SQUAL_CHAR16
,      SQUAL_CHAR17
,      SQUAL_CHAR18
,      SQUAL_CHAR19
,      SQUAL_CHAR20
,      SQUAL_CHAR21
,      SQUAL_CHAR22
,      SQUAL_CHAR23
,      SQUAL_CHAR24
,      SQUAL_CHAR25
,      SQUAL_CHAR26
,      SQUAL_CHAR27
,      SQUAL_CHAR28
,      SQUAL_CHAR30
,      SQUAL_CHAR31
,      SQUAL_CHAR32
,      SQUAL_CHAR33
,      SQUAL_CHAR34
,      SQUAL_CHAR35
,      SQUAL_CHAR36
,      SQUAL_CHAR37
,      SQUAL_CHAR38
,      SQUAL_CHAR39
,      SQUAL_CHAR40
,      SQUAL_CHAR41
,      SQUAL_CHAR42
,      SQUAL_CHAR43
,      SQUAL_CHAR44
,      SQUAL_CHAR45
,      SQUAL_CHAR46
,      SQUAL_CHAR47
,      SQUAL_CHAR48
,      SQUAL_CHAR49
,      SQUAL_CHAR50
,      SQUAL_CHAR51
,      SQUAL_CHAR52
,      SQUAL_CHAR53
,      SQUAL_CHAR54
,      SQUAL_CHAR55
,      SQUAL_CHAR56
,      SQUAL_CHAR57
,      SQUAL_CHAR58
,      SQUAL_CHAR59
,      SQUAL_CHAR60
,      SQUAL_NUM01
,      SQUAL_NUM02
,      SQUAL_NUM03
,      SQUAL_NUM04
,      SQUAL_NUM05
,      SQUAL_NUM06
,      SQUAL_NUM07
,      SQUAL_NUM08
,      SQUAL_NUM09
,      SQUAL_NUM10
,      SQUAL_NUM11
,      SQUAL_NUM12
,      SQUAL_NUM13
,      SQUAL_NUM14
,      SQUAL_NUM15
,      SQUAL_NUM16
,      SQUAL_NUM17
,      SQUAL_NUM18
,      SQUAL_NUM19
,      SQUAL_NUM20
,      SQUAL_NUM21
,      SQUAL_NUM22
,      SQUAL_NUM23
,      SQUAL_NUM24
,      SQUAL_NUM25
,      SQUAL_NUM26
,      SQUAL_NUM27
,      SQUAL_NUM28
,      SQUAL_NUM29
,      SQUAL_NUM30
,      SQUAL_NUM31
,      SQUAL_NUM32
,      SQUAL_NUM33
,      SQUAL_NUM34
,      SQUAL_NUM35
,      SQUAL_NUM36
,      SQUAL_NUM37
,      SQUAL_NUM38
,      SQUAL_NUM39
,      SQUAL_NUM40
,      SQUAL_NUM41
,      SQUAL_NUM42
,      SQUAL_NUM43
,      SQUAL_NUM44
,      SQUAL_NUM45
,      SQUAL_NUM46
,      SQUAL_NUM47
,      SQUAL_NUM48
,      SQUAL_NUM49
,      SQUAL_NUM50
,      SQUAL_NUM51
,      SQUAL_NUM52
,      SQUAL_NUM53
,      SQUAL_NUM54
,      SQUAL_NUM55
,      SQUAL_NUM56
,      SQUAL_NUM57
,      SQUAL_NUM58
,      SQUAL_NUM59
,      SQUAL_NUM60
,      ASSIGNED_FLAG
,      PROCESSED_FLAG
,      ORG_ID
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_TAE_RPT_OBJS;

Dependencies

[top of page]

JTF.JTF_TAE_RPT_OBJS does not reference any database object

JTF.JTF_TAE_RPT_OBJS is referenced by following:

SchemaAPPS
SynonymJTF_TAE_RPT_OBJS