[Home] [Help] [Dependency Information]
Object Name: | JTM_CONC_RUN_STATUS_LOG |
---|---|
Object Type: | TABLE |
Owner: | JTM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTM_CONC_RUN_STATUS_LOG_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LOG_ID |
JTM_CONC_RUN_STATUS_LOG_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PACKAGE_NAME
PROCEDURE_NAME |
JTM_CONC_RUN_STATUS_LOG_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CONC_QUERY_ID |
JTM_CONC_RUN_STATUS_LOG_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | END_TIME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_ID | NUMBER | (15) | Yes | Log Identifier |
PACKAGE_NAME | VARCHAR2 | (30) | Package which contains the procedure which was executed | |
PROCEDURE_NAME | VARCHAR2 | (30) | Procdure that got called by the Concurrent Program | |
CONC_QUERY_ID | NUMBER | (15) | Query Identifier thats run by the JTM concurrent program to populate the ACC tables. | |
PUB_NAME | VARCHAR2 | (30) | Publication Item Name | |
PUB_ITEM_NAME | VARCHAR2 | (30) | Publication Item Name | |
QUERY_STMT | VARCHAR2 | (2000) | Query that was run | |
MESSAGE | VARCHAR2 | (2000) | Additional Information | |
STATUS | VARCHAR2 | (30) | Completed / Failed / Start | |
START_TIME | DATE | Time when it began to run | ||
END_TIME | DATE | Time when it finished running | ||
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT LOG_ID
, PACKAGE_NAME
, PROCEDURE_NAME
, CONC_QUERY_ID
, PUB_NAME
, PUB_ITEM_NAME
, QUERY_STMT
, MESSAGE
, STATUS
, START_TIME
, END_TIME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM JTM.JTM_CONC_RUN_STATUS_LOG;
JTM.JTM_CONC_RUN_STATUS_LOG does not reference any database object
JTM.JTM_CONC_RUN_STATUS_LOG is referenced by following:
|
|
|