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_STEP_COLS

Object Details

Object Name:	JTF_DIAGNOSTIC_DECL_STEP_COLS
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_DIAGNOSTIC_DECL_STEP_COLS
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 name for the declarative test
TESTSTEPNAME	VARCHAR2	(200)	Name of the sub test within the declarative test
COLUMN_NAME	VARCHAR2	(300)	Name of the column
LOGICAL_OPERATOR	VARCHAR2	(20)	logical operator used to make comparison
VALIDATION_VAL1	VARCHAR2	(300)	validation value 1 used to compare actual with desired
VALIDATION_VAL2	VARCHAR2	(300)	validation value 2 used to make comparison incase 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
,      COLUMN_NAME
,      LOGICAL_OPERATOR
,      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_STEP_COLS;

Dependencies

[top of page]

JTF.JTF_DIAGNOSTIC_DECL_STEP_COLS does not reference any database object

JTF.JTF_DIAGNOSTIC_DECL_STEP_COLS is referenced by following:

JTF: JTF_DIAGNOSTIC_DECL_STEP_COLS#