eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: JTF.JTF_DIAGNOSTIC_DECL_TEST_STEPS

Object Details

Object Name:	JTF_DIAGNOSTIC_DECL_TEST_STEPS
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_DIAGNOSTIC_DECL_TEST_STEPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
APPID	VARCHAR2	(200)	application short name
GROUPNAME	VARCHAR2	(500)	groupname
TESTCLASSNAME	VARCHAR2	(1500)	test class name
TESTSTEPNAME	VARCHAR2	(200)	name of the step
EXECUTION_SEQUENCE	NUMBER	(5)	execution sequence
STEP_TYPE	VARCHAR2	(100)	type of the step
STEP_DESCRIPTION	VARCHAR2	(2000)	description
ERROR_TYPE	VARCHAR2	(25)	normal, warning or fatal
ERROR_MESSAGE	VARCHAR2	(1000)	error message for this step
FIX_INFO	VARCHAR2	(1000)	fix information for this step
MULTI_ORG	VARCHAR2	(1)	later use
TABLE_VIEW_NAME	VARCHAR2	(300)	name of the table from which the sql query is generated
WHERE_CLAUSE_OR_SQL	VARCHAR2	(4000)	where clause for the query
PROFILE_NAME	VARCHAR2	(300)	for later use
PROFILE_VALUE	VARCHAR2	(300)	for later use
LOGICAL_OPERATOR	VARCHAR2	(20)	logical operator to be used for making comparisons
FUNCTION_NAME	VARCHAR2	(250)	function name : for later use
VALIDATION_VAL1	VARCHAR2	(1000)	validation val is the desired value to which the actual value is comared to
VALIDATION_VAL2	VARCHAR2	(1000)	validation val 2 is used incase the logical operator is between
OBJECT_VERSION_NUMBER	NUMBER		standard who column
CREATED_BY	NUMBER	(15)	standard who column
LAST_UPDATE_DATE	DATE		standard who column
LAST_UPDATED_BY	NUMBER	(15)	standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	standard who column
CREATION_DATE	DATE		standard who column
SECURITY_GROUP_ID	NUMBER		standard who column

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

Dependencies

[top of page]

JTF.JTF_DIAGNOSTIC_DECL_TEST_STEPS does not reference any database object

JTF.JTF_DIAGNOSTIC_DECL_TEST_STEPS is referenced by following:

JTF: JTF_DIAGNOSTIC_DECL_TEST_STEP#