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

VIEW: JTF.JTF_DIAGNOSTIC_DECL_TEST_STEP#

Object Details
Object Name: JTF_DIAGNOSTIC_DECL_TEST_STEP#
Object Type: VIEW
Owner: JTF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPID VARCHAR2 (200)
GROUPNAME VARCHAR2 (500)
TESTCLASSNAME VARCHAR2 (1500)
TESTSTEPNAME VARCHAR2 (200)
EXECUTION_SEQUENCE NUMBER (5)
STEP_TYPE VARCHAR2 (100)
STEP_DESCRIPTION VARCHAR2 (2000)
ERROR_TYPE VARCHAR2 (25)
ERROR_MESSAGE VARCHAR2 (1000)
FIX_INFO VARCHAR2 (1000)
MULTI_ORG VARCHAR2 (1)
TABLE_VIEW_NAME VARCHAR2 (300)
WHERE_CLAUSE_OR_SQL VARCHAR2 (4000)
PROFILE_NAME VARCHAR2 (300)
PROFILE_VALUE VARCHAR2 (300)
LOGICAL_OPERATOR VARCHAR2 (20)
FUNCTION_NAME VARCHAR2 (250)
VALIDATION_VAL1 VARCHAR2 (1000)
VALIDATION_VAL2 VARCHAR2 (1000)
OBJECT_VERSION_NUMBER NUMBER

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE

SECURITY_GROUP_ID NUMBER

Query Text

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


SELECT APPID
,      GROUPNAME
,      TESTCLASSNAME
,      TESTSTEPNAME
,      EXECUTION_SEQUENCE
,      STEP_TYPE
,      STEP_DESCRIPTION
,      ERROR_TYPE
,      ERROR_MESSAGE
,      FIX_INFO
,      MULTI_ORG
,      TABLE_VIEW_NAME
,      WHERE_CLAUSE_OR_SQL
,      PROFILE_NAME
,      PROFILE_VALUE
,      LOGICAL_OPERATOR
,      FUNCTION_NAME
,      VALIDATION_VAL1
,      VALIDATION_VAL2
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      SECURITY_GROUP_ID
FROM JTF.JTF_DIAGNOSTIC_DECL_TEST_STEP#;

Dependencies

[top of page]

JTF.JTF_DIAGNOSTIC_DECL_TEST_STEP# references the following:

SchemaJTF
TableJTF_DIAGNOSTIC_DECL_TEST_STEPS
JTF.JTF_DIAGNOSTIC_DECL_TEST_STEP# is referenced by following:

SchemaAPPS
SynonymJTF_DIAGNOSTIC_DECL_TEST_STEPS