eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JTF.JTF_RS_UPLOAD_DATA

Object Details

Object Name:	JTF_RS_UPLOAD_DATA
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_RS_UPLOAD_DATA
Subobject Name:
Status:	VALID

This table stroes the information about upload data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_RS_UPLOAD_DATA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UPLOAD_DATA_ID
JTF_RS_UPLOAD_DATA_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_NO
JTF_RS_UPLOAD_DATA_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UPLOAD_DATA_ID	NUMBER		Yes	Upload data unique identifier.
TRANSACTION_NO	NUMBER		Yes	Transaction number associated with each run of data upload.
REQUEST_ID	NUMBER			Concurrent request identifier.
RECORD_NO	NUMBER		Yes	Record number.
PROCESS_STATUS	VARCHAR2	(1)	Yes	Status of current process.
COLUMN1	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN2	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN3	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN4	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN5	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN6	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN7	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN8	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN9	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN10	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN11	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN12	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN13	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN14	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN15	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN16	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN17	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN18	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN19	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN20	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN21	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN22	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN23	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN24	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN25	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN26	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN27	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN28	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN29	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN30	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN31	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN32	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN33	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN34	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN35	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN36	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN37	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN38	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN39	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN40	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN41	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN42	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN43	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN44	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN45	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN46	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN47	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN48	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN49	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN50	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN51	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN52	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN53	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN54	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN55	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN56	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN57	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN58	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN59	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
COLUMN60	VARCHAR2	(260)		Column mapped to data upload process in Excel spreadsheet.
ERROR_TEXT	VARCHAR2	(4000)		Error text for the data import process.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
OBJECT_VERSION_NUMBER	NUMBER		Yes	object version number is used to track the updates of the current row

Query Text

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


SELECT UPLOAD_DATA_ID
,      TRANSACTION_NO
,      REQUEST_ID
,      RECORD_NO
,      PROCESS_STATUS
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      COLUMN11
,      COLUMN12
,      COLUMN13
,      COLUMN14
,      COLUMN15
,      COLUMN16
,      COLUMN17
,      COLUMN18
,      COLUMN19
,      COLUMN20
,      COLUMN21
,      COLUMN22
,      COLUMN23
,      COLUMN24
,      COLUMN25
,      COLUMN26
,      COLUMN27
,      COLUMN28
,      COLUMN29
,      COLUMN30
,      COLUMN31
,      COLUMN32
,      COLUMN33
,      COLUMN34
,      COLUMN35
,      COLUMN36
,      COLUMN37
,      COLUMN38
,      COLUMN39
,      COLUMN40
,      COLUMN41
,      COLUMN42
,      COLUMN43
,      COLUMN44
,      COLUMN45
,      COLUMN46
,      COLUMN47
,      COLUMN48
,      COLUMN49
,      COLUMN50
,      COLUMN51
,      COLUMN52
,      COLUMN53
,      COLUMN54
,      COLUMN55
,      COLUMN56
,      COLUMN57
,      COLUMN58
,      COLUMN59
,      COLUMN60
,      ERROR_TEXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTF_RS_UPLOAD_DATA;

Dependencies

[top of page]

JTF.JTF_RS_UPLOAD_DATA does not reference any database object

JTF.JTF_RS_UPLOAD_DATA is referenced by following:

APPS: JTF_RS_UPLOAD_DATA