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

TABLE: JTF.JTF_DIAGNOSTIC_GROUP

Object Details
Object Name: JTF_DIAGNOSTIC_GROUP
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_DIAGNOSTIC_GROUP
Subobject Name:
Status: VALID


Stores info about groups registered within a registered applications


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_DIAGNOSTIC_GROUP_UK1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAPPID
ColumnGROUPNAME
ColumnZD_EDITION_NAME
JTF_DIAGNOSTIC_GROUP_UK2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAPPID
ColumnORDERNUMBER
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
SEQUENCE NUMBER (15) Yes sequence
GROUPNAME VARCHAR2 (500) Yes Groupname
APPID VARCHAR2 (200) Yes App short name
ORDERNUMBER NUMBER (3) Yes sequence within application
OBJECT_VERSION_NUMBER NUMBER
Yes standard who column
CREATED_BY NUMBER (15) Yes standard who column
LAST_UPDATE_DATE DATE
Yes standard who column
LAST_UPDATED_BY NUMBER (15) Yes standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column
CREATION_DATE DATE
Yes standard who column
SECURITY_GROUP_ID NUMBER

standard who column
SENSITIVITY NUMBER
Yes sensitivity of the group wrt to testcases in it
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT SEQUENCE
,      GROUPNAME
,      APPID
,      ORDERNUMBER
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      SECURITY_GROUP_ID
,      SENSITIVITY
,      ZD_EDITION_NAME
FROM JTF.JTF_DIAGNOSTIC_GROUP;

Dependencies

[top of page]

JTF.JTF_DIAGNOSTIC_GROUP does not reference any database object

JTF.JTF_DIAGNOSTIC_GROUP is referenced by following:

SchemaJTF
ViewJTF_DIAGNOSTIC_GROUP#