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

TABLE: AHL.AHL_DOC_TITLE_ASSOS_TL

Object Details
Object Name: AHL_DOC_TITLE_ASSOS_TL
Object Type: TABLE
Owner: AHL
FND Design Data: TableAHL.AHL_DOC_TITLE_ASSOS_TL
Subobject Name:
Status: VALID


This table stores the translated columns information for the association between document or document revision and ASO object.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AHL_DOC_TITLE_ASSOS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDOC_TITLE_ASSO_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
DOC_TITLE_ASSO_ID NUMBER
Yes Foreign Key to AHL_DOC_TITLE_ASSOS_B
LANGUAGE VARCHAR2 (4) Yes The defined language code for the row's translated columns
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SOURCE_LANG VARCHAR2 (4) Yes Indicates the actual language of the row's translated columns
CHAPTER VARCHAR2 (30)
Chapter of the document
SECTION VARCHAR2 (30)
Section of the document
SUBJECT VARCHAR2 (240)
Subject of the document
PAGE VARCHAR2 (5)
Page of the document
FIGURE VARCHAR2 (30)
Figure
NOTE VARCHAR2 (2000)
Note
SECURITY_GROUP_ID NUMBER

Used in application hosting
Query Text

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


SELECT DOC_TITLE_ASSO_ID
,      LANGUAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE_LANG
,      CHAPTER
,      SECTION
,      SUBJECT
,      PAGE
,      FIGURE
,      NOTE
,      SECURITY_GROUP_ID
FROM AHL.AHL_DOC_TITLE_ASSOS_TL;

Dependencies

[top of page]

AHL.AHL_DOC_TITLE_ASSOS_TL does not reference any database object

AHL.AHL_DOC_TITLE_ASSOS_TL is referenced by following:

SchemaAHL
ViewAHL_DOC_TITLE_ASSOS_TL#