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

TABLE: JTF.JTF_HEADER_DTD

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


table to store common header DTD.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000084358C00003$$ LOB UNIQUE TablespaceAPPS_TS_SEED
Columns
Name Datatype Length Mandatory Comments
HEADER_DTD_ID NUMBER
Yes
DTD_NAME VARCHAR2 (50)
HEADER_DTD CLOB (4000)
ACTIVE_FLAG VARCHAR2 (1)
active flag Y/N
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE1 VARCHAR2 (50)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (50)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (50)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (50)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (50)
Descriptive flexfield segment
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT HEADER_DTD_ID
,      DTD_NAME
,      HEADER_DTD
,      ACTIVE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ZD_EDITION_NAME
FROM JTF.JTF_HEADER_DTD;

Dependencies

[top of page]

JTF.JTF_HEADER_DTD does not reference any database object

JTF.JTF_HEADER_DTD is referenced by following:

SchemaJTF
ViewJTF_HEADER_DTD#