[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
GR.GR_WORK_BUILD_DOCS does not reference any database object
GR.GR_WORK_BUILD_DOCS is referenced by following:
|
|
|