eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GR.GR_DOCUMENT_STRUCTURES

Object Details

Object Name:	GR_DOCUMENT_STRUCTURES
Object Type:	TABLE
Owner:	GR
FND Design Data:	GR.GR_DOCUMENT_STRUCTURES
Subobject Name:
Status:	VALID

Contains the detailed breakdown of how the document will display or print. A row of date format and detailed ingredient, toxic, and exposure information information must be defined in the Document Code entity before structure details are built.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_DOCUMENT_STRUCTURES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_STRUCTURES_SEQNO DOCUMENT_HEADINGS_SEQNO
GR_DOCUMENT_STRUCTURES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_HEADINGS_SEQNO
GR_DOCUMENT_STRUCTURES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LABEL_CODE
GR_DOCUMENT_STRUCTURES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHRASE_GROUP_CODE
GR_DOCUMENT_STRUCTURES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHRASE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_STRUCTURES_SEQNO	NUMBER		Yes	The Regulatory module assigns an internally-controlled sequence number for labels and phrases within the document structure.
DOCUMENT_HEADINGS_SEQNO	NUMBER		Yes	Surrogate key for the item.
LABEL_CODE	VARCHAR2	(5)		The Code that will be used in the Regulatory module to reference the label information for the Item. Label Codes such as Boiling and Flash Points and PH are prepopulated in the Regulatory module. Additional label codes can also be typed.
PHRASE_GROUP_CODE	VARCHAR2	(10)		The Phrase Group Code.
PHRASE_CODE	VARCHAR2	(10)		The Code assigned to the Phrase.
PRINT_FONT	VARCHAR2	(3)		The Print Font that will be used in the document.
DATA_POSITION_INDICATOR	VARCHAR2	(1)		The Data Position Indicator defaults from the same attribute in the Label entity and can be overridden by typing a valid value. Valid values are:I - Print the data immediately after the label.C - Print the data starting in the center of the line.R - Print the data right justified.N - Print the data, left justified on the next line and retain the print font for the label.
DISPLAY_ORDER	NUMBER	(15)	Yes	Display Order value is used to arrange the sections of the Document as required.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining Column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Standard Flexfield Segment Column
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
DOCUMENT_DESCRIPTION	VARCHAR2	(240)		Column to be made null as a new table GR_DOCUMENT_CODES_TL has been added to hold description

Query Text

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


SELECT DOCUMENT_STRUCTURES_SEQNO
,      DOCUMENT_HEADINGS_SEQNO
,      LABEL_CODE
,      PHRASE_GROUP_CODE
,      PHRASE_CODE
,      PRINT_FONT
,      DATA_POSITION_INDICATOR
,      DISPLAY_ORDER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DOCUMENT_DESCRIPTION
FROM GR.GR_DOCUMENT_STRUCTURES;

Dependencies

[top of page]

GR.GR_DOCUMENT_STRUCTURES does not reference any database object

GR.GR_DOCUMENT_STRUCTURES is referenced by following:

APPS: GR_DOCUMENT_STRUCTURES