[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTY_CONC_REQ_SUMM_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PARAM1
RETCODE PROGRAM_NAME |
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 |
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;
JTF.JTY_CONC_REQ_SUMM does not reference any database object
JTF.JTY_CONC_REQ_SUMM is referenced by following:
|
|
|