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

TABLE: GR.GR_DOCUMENT_DETAILS

Object Details
Object Name: GR_DOCUMENT_DETAILS
Object Type: TABLE
Owner: GR
FND Design Data: TableGR.GR_DOCUMENT_DETAILS
Subobject Name:
Status: VALID


Contains each phrase as it will display or print on the document.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_DOCUMENT_DETAILS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTEXT_LINE_NUMBER
ColumnDOCUMENT_TEXT_ID
GR_DOCUMENT_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCUMENT_TEXT_ID
Columns
Name Datatype Length Mandatory Comments
TEXT_LINE_NUMBER NUMBER (6) Yes The line number where the text will be displayed or printed.
DOCUMENT_TEXT_ID NUMBER (15) Yes The Text ID for the document that is being printed.
PRINT_FONT VARCHAR2 (3)
The font information for the line of text.
PRINT_SIZE NUMBER (2)
The font size in which the document is to be printed.
TEXT_LINE VARCHAR2 (132)
The actual text that will be printed next to the label.
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LINE_TYPE VARCHAR2 (3)
Type of Line
Query Text

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


SELECT TEXT_LINE_NUMBER
,      DOCUMENT_TEXT_ID
,      PRINT_FONT
,      PRINT_SIZE
,      TEXT_LINE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LINE_TYPE
FROM GR.GR_DOCUMENT_DETAILS;

Dependencies

[top of page]

GR.GR_DOCUMENT_DETAILS does not reference any database object

GR.GR_DOCUMENT_DETAILS is referenced by following:

SchemaAPPS
SynonymGR_DOCUMENT_DETAILS