[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GR_LABELS_B |
|---|---|
| Object Type: | TABLE |
| Owner: | GR |
| FND Design Data: |  GR.GR_LABELS_B
|
| Subobject Name: | |
| Status: | VALID |
Contains many label classes, each containing many rows that define the format and text for each line on the document. For example, a label of BOILING will determine how and where the physical characteristics of boiling point display on the document.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GR_LABELS_B_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LABEL_CODE
|
| GR_LABELS_B_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LABEL_CLASS_CODE
|
| GR_LABELS_B_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SAFETY_CATEGORY_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LABEL_CODE | VARCHAR2 | (5) | Yes | 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. |
| SAFETY_CATEGORY_CODE | VARCHAR2 | (3) | Yes | The Safety Category Code. |
| LABEL_CLASS_CODE | VARCHAR2 | (20) | Yes | The label class code for the item. |
| DATA_POSITION_INDICATOR | VARCHAR2 | (1) | Yes | Identifies where on the print line the data associated with the label will display or print. The default is C. Valid values are:I - Immediately after the label.C - Starting at the center of the line.R - Right justified.N - Left justified on the next line and retains the print font definition specified for the Label. |
| LABEL_PROPERTIES_FLAG | VARCHAR2 | (1) | Yes | Label properties flag. |
| ITEM_PROPERTIES_FLAG | VARCHAR2 | (1) | Yes | Y or N to indicate whether the Item Properties are maintained for the Label. |
| INGREDIENT_VALUE_FLAG | VARCHAR2 | (1) | Yes | Y or N to indicate whether the Ingredient Values will be displayed or printed on the document. The default is N. |
| INHERIT_FROM_LABEL_CODE | VARCHAR2 | (5) | The specific Label Code that the item information will be copied from as default. | |
| PRINT_INGREDIENT_INDICATOR | VARCHAR2 | (1) | A valid Print Ingredient Indicator to determine how the Ingredient information will be displayed or printed. Valid values are:P - Concentration percentage will print on the label.B - Concentration percentage will not print on the label.A - The alphanumeric value of the ingredient will print on the label.N - The numeric value of the ingredient will print on the label. | |
| PRINT_FONT | VARCHAR2 | (3) | The Print Font that will be used in the document. | |
| PRINT_SIZE | NUMBER | (2) | The Print Size that will be used in the document. | |
| INGREDIENT_LABEL_CODE | VARCHAR2 | (5) | The Label Code for the Ingredient. | |
| VALUE_PROCEDURE | VARCHAR2 | (24) | Contains the name of the stored procedure that is called for the label. | |
| 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 | |
| LABEL_VALUE_REQUIRED | NUMBER | (5) | Valid Values - 0-Not Required, 1-Required | |
| TECH_PARM | VARCHAR2 | (1) | Laboratory Technical Parameter | |
| ROLLUP_DISCLOSURE_CODE | VARCHAR2 | (10) | New Column for disclosures |
Cut, paste (and edit) the following text to query this object:
SELECT LABEL_CODE
, SAFETY_CATEGORY_CODE
, LABEL_CLASS_CODE
, DATA_POSITION_INDICATOR
, LABEL_PROPERTIES_FLAG
, ITEM_PROPERTIES_FLAG
, INGREDIENT_VALUE_FLAG
, INHERIT_FROM_LABEL_CODE
, PRINT_INGREDIENT_INDICATOR
, PRINT_FONT
, PRINT_SIZE
, INGREDIENT_LABEL_CODE
, VALUE_PROCEDURE
, 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
, LABEL_VALUE_REQUIRED
, TECH_PARM
, ROLLUP_DISCLOSURE_CODE
FROM GR.GR_LABELS_B;
GR.GR_LABELS_B does not reference any database object
GR.GR_LABELS_B is referenced by following:
APPS
GR_LABELS_B
|
|
|
|