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_WORK_BUILD_DOCS

Object Details

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

Contains a temporary table used during the document build process.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GR_WORK_BUILD_DOCS_PK	NORMAL	UNIQUE	APPS_TS_NOLOGGING	SESSION_ID SEQUENCE_NUMBER
GR_WORK_BUILD_DOCS_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	DOCUMENT_CODE MAIN_HEADING_CODE SUB_HEADING_CODE RECORD_TYPE LABEL_OR_PHRASE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	Surrogate key
SEQUENCE_NUMBER	NUMBER		Yes	Display order
DOCUMENT_CODE	VARCHAR2	(10)	Yes	Document Code
MAIN_HEADING_CODE	VARCHAR2	(10)	Yes	The Main Heading Code where the heading text is located.
MAIN_DISPLAY_ORDER	NUMBER	(15)	Yes	Main Heading display order
SUB_HEADING_CODE	VARCHAR2	(10)		The Sub Heading Code where the heading text is located.
SUB_DISPLAY_ORDER	NUMBER	(15)		Sub Heading Display Order
RECORD_TYPE	VARCHAR2	(1)	Yes	Record Type
LABEL_OR_PHRASE_CODE	VARCHAR2	(10)		The Code can be used in the Regulatory module to reference the label information or the phrase information for the Item .
CONCENTRATION_PERCENT	NUMBER	(15)	Yes	The percentage concentration of the finished product.
LABEL_CLASS	VARCHAR2	(20)		The label class for the item.
PHRASE_HIERARCHY	NUMBER	(6)		The Phrase Heirarchy for the phrase on the document if it conflicts with another phrase. When 2 phrase codes have the same Hierarchy Type, the phrase with the higher Hierarchy Code will take precedence and display or print on the document.
PHRASE_TYPE	VARCHAR2	(10)		Phrase Type
PRINT_FLAG	VARCHAR2	(1)	Yes	Print Flag
SOURCE_ITEMCODE	VARCHAR2	(32)	Yes	The Source Item Code for which source item text is located.
STRUCTURE_DISPLAY_ORDER	NUMBER	(15)		Structure Display Order

Query Text

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


SELECT SESSION_ID
,      SEQUENCE_NUMBER
,      DOCUMENT_CODE
,      MAIN_HEADING_CODE
,      MAIN_DISPLAY_ORDER
,      SUB_HEADING_CODE
,      SUB_DISPLAY_ORDER
,      RECORD_TYPE
,      LABEL_OR_PHRASE_CODE
,      CONCENTRATION_PERCENT
,      LABEL_CLASS
,      PHRASE_HIERARCHY
,      PHRASE_TYPE
,      PRINT_FLAG
,      SOURCE_ITEMCODE
,      STRUCTURE_DISPLAY_ORDER
FROM GR.GR_WORK_BUILD_DOCS;

Dependencies

[top of page]

GR.GR_WORK_BUILD_DOCS does not reference any database object

GR.GR_WORK_BUILD_DOCS is referenced by following:

APPS: GR_WORK_BUILD_DOCS