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

TABLE: JTF.JTF_TAE_1001_QUOTE_NM_TRANS

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


This table stores the input data for the new mode BULK TAE.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_TAE_TN1105_CASE_N1W NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANS_OBJECT_ID
Columns
Name Datatype Length Mandatory Comments
TRANS_OBJECT_ID NUMBER
Yes Transaction object ID
TRANS_DETAIL_OBJECT_ID NUMBER

Transaction detail object ID
SOURCE_ID NUMBER

Source ID
TRANS_OBJECT_TYPE_ID NUMBER

Transaction object type ID
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Program Who Column
PROGRAM_APPLICATION_ID NUMBER

Program Who Column
PROGRAM_ID NUMBER

Program Who Column
PROGRAM_UPDATE_DATE DATE

Program Who Column
ORDER_ID NUMBER

Order ID
QUOTE_EXPIRATION_DATE DATE

Quote expiration date
SQUAL_CHAR01 VARCHAR2 (360)
char data 1
SQUAL_CHAR02 VARCHAR2 (360)
char data 2
SQUAL_CHAR03 VARCHAR2 (360)
char data 3
SQUAL_CHAR04 VARCHAR2 (360)
char data 4
SQUAL_CHAR05 VARCHAR2 (360)
char data 5
SQUAL_CHAR06 VARCHAR2 (360)
char data 6
SQUAL_CHAR07 VARCHAR2 (360)
char data 7
SQUAL_CHAR08 VARCHAR2 (360)
char data 8
SQUAL_CHAR09 VARCHAR2 (360)
char data 9
SQUAL_CHAR10 VARCHAR2 (360)
char data 10
SQUAL_CHAR11 VARCHAR2 (360)
char data 11
SQUAL_NUM01 NUMBER

number data 1
SQUAL_NUM02 NUMBER

number data 2
SQUAL_NUM03 NUMBER

number data 3
SQUAL_NUM04 NUMBER

number data 4
SQUAL_NUM05 NUMBER

number data 5
SQUAL_NUM06 NUMBER

number data 6
SQUAL_NUM50 NUMBER

number data 50
SQUAL_FC01 VARCHAR2 (3)
fc data 1
SQUAL_CURC01 VARCHAR2 (30)
curc data 1
TXN_DATE DATE

transaction date
SECURITY_GROUP_ID NUMBER

used in hosting environment
OBJECT_VERSION_NUMBER NUMBER

Object version number
WORKER_ID NUMBER

Worker ID
Query Text

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


SELECT TRANS_OBJECT_ID
,      TRANS_DETAIL_OBJECT_ID
,      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
,      ORDER_ID
,      QUOTE_EXPIRATION_DATE
,      SQUAL_CHAR01
,      SQUAL_CHAR02
,      SQUAL_CHAR03
,      SQUAL_CHAR04
,      SQUAL_CHAR05
,      SQUAL_CHAR06
,      SQUAL_CHAR07
,      SQUAL_CHAR08
,      SQUAL_CHAR09
,      SQUAL_CHAR10
,      SQUAL_CHAR11
,      SQUAL_NUM01
,      SQUAL_NUM02
,      SQUAL_NUM03
,      SQUAL_NUM04
,      SQUAL_NUM05
,      SQUAL_NUM06
,      SQUAL_NUM50
,      SQUAL_FC01
,      SQUAL_CURC01
,      TXN_DATE
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      WORKER_ID
FROM JTF.JTF_TAE_1001_QUOTE_NM_TRANS;

Dependencies

[top of page]

JTF.JTF_TAE_1001_QUOTE_NM_TRANS does not reference any database object

JTF.JTF_TAE_1001_QUOTE_NM_TRANS is referenced by following:

SchemaAPPS
SynonymJTF_TAE_1001_QUOTE_NM_TRANS