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

TABLE: JTF.JTF_DIAGNOSTIC_PREREQ

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


Stores info about group and application prereqs for diagnostics


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_DIAGNOSTIC_PREREQ_UK1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnSOURCEAPPID
ColumnSOURCEID
ColumnPREREQID
ColumnZD_EDITION_NAME
JTF_DIAGNOSTIC_PREREQ_IDX1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSOURCEAPPID
ColumnPREREQID
JTF_DIAGNOSTIC_PREREQ_IDX2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSOURCEAPPID
ColumnSOURCEID
Columns
Name Datatype Length Mandatory Comments
SEQUENCE NUMBER (15) Yes sequence
SOURCEID VARCHAR2 (200) Yes Group name or app short name
PREREQID VARCHAR2 (500) Yes Group name or app short name
SOURCEAPPID VARCHAR2 (200) Yes app short name for group
TYPE NUMBER (1) Yes flag if this is app or group
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
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT SEQUENCE
,      SOURCEID
,      PREREQID
,      SOURCEAPPID
,      TYPE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM JTF.JTF_DIAGNOSTIC_PREREQ;

Dependencies

[top of page]

JTF.JTF_DIAGNOSTIC_PREREQ does not reference any database object

JTF.JTF_DIAGNOSTIC_PREREQ is referenced by following:

SchemaJTF
ViewJTF_DIAGNOSTIC_PREREQ#