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.JTY_CONC_REQ_SUMM

Object Details

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

This table stores concurrent request summary.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTY_CONC_REQ_SUMM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARAM1 RETCODE PROGRAM_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
CONC_REQ_ID	NUMBER		Yes	Primary key
REQUESTED_BY	NUMBER			Requested By
REQUEST_DATE	DATE			Request date
RESPONSIBILITY_APPLICATION_ID	NUMBER			Responsibility application ID
RESPONSIBILITY_ID	NUMBER			Responsibility ID
LAST_UPDATED_BY	NUMBER			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
START_DATE	DATE			Start date
END_DATE	DATE			End date
PARAM1	VARCHAR2	(360)		Parameter 1
PARAM2	VARCHAR2	(360)		Parameter 2
PARAM3	VARCHAR2	(360)		Parameter 3
PARAM4	VARCHAR2	(360)		Parameter 4
PARAM5	VARCHAR2	(360)		Parameter 5
PROGRAM_APPLICATION_ID	NUMBER			Program application ID
PROGRAM_NAME	VARCHAR2	(360)		Program name
RETCODE	VARCHAR2	(250)		Return code from concurrent program
ERRBUF	VARCHAR2	(3000)		Error buffer from concurrent program
REQUEST_ID	NUMBER			Request ID
CONC_PROGRAM_ID	NUMBER			Concurrent program ID
OBJECT_VERSION_NUMBER	NUMBER			Object version number

Query Text

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


SELECT CONC_REQ_ID
,      REQUESTED_BY
,      REQUEST_DATE
,      RESPONSIBILITY_APPLICATION_ID
,      RESPONSIBILITY_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      START_DATE
,      END_DATE
,      PARAM1
,      PARAM2
,      PARAM3
,      PARAM4
,      PARAM5
,      PROGRAM_APPLICATION_ID
,      PROGRAM_NAME
,      RETCODE
,      ERRBUF
,      REQUEST_ID
,      CONC_PROGRAM_ID
,      OBJECT_VERSION_NUMBER
FROM JTF.JTY_CONC_REQ_SUMM;

Dependencies

[top of page]

JTF.JTY_CONC_REQ_SUMM does not reference any database object

JTF.JTY_CONC_REQ_SUMM is referenced by following:

APPS: JTY_CONC_REQ_SUMM