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

VIEW: JTM.JTM_CON_REQUEST_DATA#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PRODUCT_CODE VARCHAR2 (30) Yes
PACKAGE_NAME VARCHAR2 (30) Yes
PROCEDURE_NAME VARCHAR2 (30) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
EXECUTE_FLAG VARCHAR2 (1) Yes
EXECUTION_ORDER NUMBER (15) Yes
INTERVAL_ID NUMBER (15) Yes
LAST_RUN_DATE DATE

LAST_TXC_START DATE

LAST_TXC_END DATE

COMPLETION_TEXT VARCHAR2 (2000)
CATEGORY VARCHAR2 (80)
ORIGINAL_EXECUTE_FLAG VARCHAR2 (1)
ORIGINAL_CATEGORY VARCHAR2 (80)
DESCRIPTION VARCHAR2 (2000)
STATUS VARCHAR2 (30)
USER_UPDATE_FLAG VARCHAR2 (1)
FORCE_UPDATE_FLAG VARCHAR2 (1)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT PRODUCT_CODE
,      PACKAGE_NAME
,      PROCEDURE_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      EXECUTE_FLAG
,      EXECUTION_ORDER
,      INTERVAL_ID
,      LAST_RUN_DATE
,      LAST_TXC_START
,      LAST_TXC_END
,      COMPLETION_TEXT
,      CATEGORY
,      ORIGINAL_EXECUTE_FLAG
,      ORIGINAL_CATEGORY
,      DESCRIPTION
,      STATUS
,      USER_UPDATE_FLAG
,      FORCE_UPDATE_FLAG
,      ZD_EDITION_NAME
FROM JTM.JTM_CON_REQUEST_DATA#;

Dependencies

[top of page]

JTM.JTM_CON_REQUEST_DATA# references the following:

SchemaJTM
TableJTM_CON_REQUEST_DATA
JTM.JTM_CON_REQUEST_DATA# is referenced by following:

SchemaAPPS
SynonymJTM_CON_REQUEST_DATA
TriggerJTM_CON_REQUEST_DATA+