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


VIEW: JTM.JTM_CONC_RUN_STATUS_LOG#

Object Details
Object Name: JTM_CONC_RUN_STATUS_LOG#
Object Type: VIEW
Owner: JTM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOG_ID NUMBER (15) Yes
PACKAGE_NAME VARCHAR2 (30)
PROCEDURE_NAME VARCHAR2 (30)
CONC_QUERY_ID NUMBER (15)
PUB_NAME VARCHAR2 (30)
PUB_ITEM_NAME VARCHAR2 (30)
QUERY_STMT VARCHAR2 (2000)
MESSAGE VARCHAR2 (2000)
STATUS VARCHAR2 (30)
START_TIME DATE

END_TIME DATE

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
Query Text

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#;

Dependencies

[top of page]

JTM.JTM_CONC_RUN_STATUS_LOG# references the following:

SchemaJTM
TableJTM_CONC_RUN_STATUS_LOG
JTM.JTM_CONC_RUN_STATUS_LOG# is referenced by following:

SchemaAPPS
SynonymJTM_CONC_RUN_STATUS_LOG