[Home] [Help] [Dependency Information]
Object Name: | GR_ITEM_GENERAL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_ITEM_GENERAL |
Subobject Name: | |
Status: | VALID |
Stores regulatory information that further identifies the item. It also stores flags that govern what data displays on the MSDS.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_ITEM_GENERAL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ITEM_CODE |
GR_ITEM_GENERAL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ITEM_GROUP_CODE |
GR_ITEM_GENERAL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | USER_ID |
GR_ITEM_GENERAL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRODUCT_CLASS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_CODE | VARCHAR2 | (32) | Yes | The Item Code for the substance used in or produced by the process. |
ITEM_GROUP_CODE | VARCHAR2 | (10) | The Group Code for the Item. | |
PRIMARY_CAS_NUMBER | VARCHAR2 | (15) | The first Chemical Abstracts Service (CAS) number assigned to the material. | |
INGREDIENT_FLAG | VARCHAR2 | (1) | Identifies whether or not the item is an Ingredient (flag will be 'Y') or a product/intermediate in which case the flag will be 'N'. | |
EXPLODE_INGREDIENT_FLAG | VARCHAR2 | (1) | If the ingredient flag is set to 'Y' and the ingredient has a components of its own, the user would set this flag to 'Y' and the explosion routines will check the explosion entity. The default will be 'N'.If the ingredient flag is set to 'Y | |
FORMULA_SOURCE_INDICATOR | VARCHAR2 | (1) | Yes | Formula source indicator is used by the system to indicate which applications module is the source of the formula to be exploded, if any, for this item. |
USER_ID | NUMBER | (15) | Yes | Application user identifier. |
INTERNAL_REFERENCE_NUMBER | VARCHAR2 | (32) | The internal reference number if one has been assigned. | |
PRODUCT_LABEL_CODE | VARCHAR2 | (30) | The product's label code to determine what type of label will be displayed or printed. | |
VERSION_CODE | VARCHAR2 | (10) | A sequential number to aid in tracking the changes each time you change the document. | |
LAST_VERSION_CODE | VARCHAR2 | (10) | Maintans the Version Code for when the document was last changed. | |
PRODUCT_CLASS | VARCHAR2 | (10) | The product class codes are used to define a logical grouping of products. | |
ACTUAL_HAZARD | NUMBER | (7) | The percentage of the ingredient that is considered hazardous.Note : The value of this field is used to calculate the final percentage of the ingredient in the formula. Enter100% for pure substances and intermediates that will be exploded. | |
PRINT_INGREDIENT_PHRASES_FLAG | VARCHAR2 | (1) | Yes | Y or N to indicate whether the Ingredient Phrases will be displayed or printed on the document. |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Standard Flexfield Segment 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_CODE
, ITEM_GROUP_CODE
, PRIMARY_CAS_NUMBER
, INGREDIENT_FLAG
, EXPLODE_INGREDIENT_FLAG
, FORMULA_SOURCE_INDICATOR
, USER_ID
, INTERNAL_REFERENCE_NUMBER
, PRODUCT_LABEL_CODE
, VERSION_CODE
, LAST_VERSION_CODE
, PRODUCT_CLASS
, ACTUAL_HAZARD
, PRINT_INGREDIENT_PHRASES_FLAG
, 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
FROM GR.GR_ITEM_GENERAL;
GR.GR_ITEM_GENERAL does not reference any database object
GR.GR_ITEM_GENERAL is referenced by following:
|
|
|