[Home] [Help] [Dependency Information]
Object Name: | GR_ITEM_EXPOSURE |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_ITEM_EXPOSURE |
Subobject Name: | |
Status: | VALID |
Contains the exposure limit information for the item listed by country and authority.
The exposure limit information shown on a document is controlled in two places, at the country and document levels. At the country level, a country can select to print exposure information for another country. For example, Canada (CA) can select the exposure country code US to print exposure information for the US. At the document level, a flag indicates whether exposure limit information will be included on the document and under what heading it will be displayed.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_ITEM_EXPOSURE_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ITEM_CODE
LABEL_CODE EXPOSURE_AUTHORITY_CODE EXPOSURE_TYPE_CODE |
GR_ITEM_EXPOSURE_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LABEL_CODE |
GR_ITEM_EXPOSURE_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXPOSURE_AUTHORITY_CODE |
GR_ITEM_EXPOSURE_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EXPOSURE_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_CODE | VARCHAR2 | (32) | Yes | The Item Code for the substance used in or produced by the process. |
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. |
EXPOSURE_AUTHORITY_CODE | VARCHAR2 | (10) | Yes | The exposure authority code. |
EXPOSURE_TYPE_CODE | VARCHAR2 | (10) | Yes | Exposure Type Code. |
EXPOSURE_UOM | VARCHAR2 | (1) | Yes | The recorded concentration for the Exposure Dosage. Valid concentrations are:P - Parts per millionM - Mg/M3D - DustX - Limit not establishedO - Other. |
EXPOSURE_DOSE | NUMBER | (15) | Yes | The value for the recorded Exposure Dosage. |
EXPOSURE_TIME | VARCHAR2 | (30) | The value for the recorded Exposure Time. | |
EXPOSURE_NOTE | VARCHAR2 | (240) | Any additional notes about the Exposure Limit testing. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_CODE
, LABEL_CODE
, EXPOSURE_AUTHORITY_CODE
, EXPOSURE_TYPE_CODE
, EXPOSURE_UOM
, EXPOSURE_DOSE
, EXPOSURE_TIME
, EXPOSURE_NOTE
, 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_EXPOSURE;
GR.GR_ITEM_EXPOSURE does not reference any database object
GR.GR_ITEM_EXPOSURE is referenced by following:
|
|
|