[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GR_DOCUMENT_CODES |
|---|---|
| Object Type: | TABLE |
| Owner: | GR |
| FND Design Data: |  GR.GR_DOCUMENT_CODES
|
| Subobject Name: | |
| Status: | VALID |
Contains the date format and determines whether detailed ingredient, toxic, and exposure information displays or prints on the document. Also allows customization of the appearance of the detailed elements.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GR_DOCUMENT_CODES_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 DOCUMENT_CODE
|
| GR_DOCUMENT_CODES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
USER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DOCUMENT_CODE | VARCHAR2 | (10) | Yes | The Document Code for the document. |
| USER_ID | NUMBER | (15) | Yes | Application user identifier. |
| DOCUMENT_VERSION | NUMBER | Yes | The Document Version for the document. | |
| DOCUMENT_DESCRIPTION | VARCHAR2 | (240) | The actual name of the document. | |
| DOCUMENT_HISTORY_FLAG | VARCHAR2 | (1) | Y or N to indicate whether History information will be held for the document. | |
| ALLOW_USER_OVERRIDE | VARCHAR2 | (1) | Yes | Y or N to indicate whether the document structure can be copied and changed. |
| DOCUMENT_DATE_FORMAT | VARCHAR2 | (15) | Yes | The date format that will display or print on the document. Examples of valid date formats are: MM/DD/YY, DD/MM/YY, DD-MON-YYYY. |
| PRINT_INGREDIENTS_FLAG | VARCHAR2 | (1) | Yes | Y or N to indicate whether the Ingredient Explosion will be displayed or printed on the document. |
| INGREDIENT_HEADER_LABEL | VARCHAR2 | (30) | If the Print Ingredients Flag is set to Y, the Ingredient Header Label will be available. The Ingredient Header Label identifies the heading label where the ingredient information will display or print. | |
| INGREDIENT_CONC_IND | VARCHAR2 | (1) | A valid Ingredient Concentration Indicator to determine how the Ingredient Concentrations will be displayed or printed on the document. Valid values are: E - Exact percentage, A - Approximation to nearest 2.5%, R - Use the user defined ranges. | |
| CAS_NUMBER_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the CAS Number Sequence will be available. Type 0 to avoid displaying or printing the CAS Number. Type any other number to determine the numerical sequence number that will be used for displaying or printing the Ingredient elements. | |
| MSDS_NAME_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the MSDS Name Sequence will be available. Type 0 to avoid displaying or printing the Ingredient elements. Type any other number to determine the numerical sequence number that will be used for displaying or printing the Ingredient elements. | |
| CONCENTRATION_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the Concentration Sequence will be available. Type 0 to avoid displaying or printing the Concentration. Type any other number to determine the numerical sequence number that will be used for displaying or printing the Concentration. | |
| HMIS_CODE_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the HMIS Code Sequence will be available. Type 0 to avoid displaying or printing the Ingredient HMIS Codes. Type any other number to determine the sequence number that will be used for displaying or printing the Ingredient HMIS Codes. | |
| NFPA_CODE_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the NFPA Code Sequence will be available. Type 0 to avoid displaying or printing the NFPA Codes. Type any other number to determine the sequence number that will be used for displaying or printing the NFPA Codes. | |
| USER_CODE_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the User Code Sequence will be available. Type 0 to avoid displaying or printing the User-defined HMIS Codes. Type any other number to determine the sequence number that will be used for displaying or printing the User-defined HMIS Codes. | |
| EEC_NUMBER_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the EEC Number Sequence will be available. Type 0 to avoid displaying or printing the EEC Number. Type any other number to determine the sequence number that will be used for displaying or printing the EEC Number. | |
| HAZARD_SYMBOL_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the Hazard Symbol Sequence will be available. Type 0 to avoid displaying or printing the European Hazard Symbol. Type any other number to determine the sequence number that will be used for displaying or printing the European Hazard Symbol. | |
| RISK_PHRASE_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the Risk Phrase Sequence will be available. Type 0 to avoid displaying or printing the European Risk Phrases. Type any other number to determine the sequence number that will be used for displaying or printing the European Risk Phrases. | |
| SAFETY_PHRASE_SEQ | NUMBER | (2) | If the Print Ingredients Flag is set to Y, the Safety Phrase Sequence will be available. Type 0 to avoid displaying or printing the European Safety Phrases. Type any other number to determine the sequence number that will be used for displaying or printing the European Safety Phrases. | |
| PRINT_TOXIC_INFO_FLAG | VARCHAR2 | (1) | Yes | Y or N to indicate whether Toxicity information will be displayed or printed on the document. |
| TOXIC_HEADER_LABEL | VARCHAR2 | (30) | If the Print Toxic Information Flag is set to Y, the Toxic Header Label will be available. The Toxic Header Label identifies the heading label where the Toxic information will display or print. | |
| TOXIC_CAS_NUMBER_SEQ | NUMBER | (2) | If the Print Toxic Information Flag is set to Y, the Toxic CAS Number Sequence will be available. Type 0 to avoid displaying or printing the CAS Number. Type any other number to determine the sequence number that will be used for displaying or printing the CAS Number. | |
| TOXIC_MSDS_NAME_SEQ | NUMBER | (2) | If the Print Toxic Information Flag is set to Y, the Toxic MSDS Name Sequence will be available. Type 0 to avoid displaying or printing the MSDS Name. Type any other number to determine the sequence number that will be used for displaying or printing the MSDS Name. | |
| TOXIC_ROUTE_SEQ | NUMBER | (2) | If the Print Toxic Information Flag is set to Y, the Toxic Route Sequence will be available. Type 0 to avoid displaying or printing theToxic Route. Type any other number to determine the sequence number that will be used for displaying or printing the Toxic Route. | |
| TOXIC_SPECIES_SEQ | NUMBER | (2) | If the Print Toxic Information Flag is set to Y, the Toxic Species Sequence will be available. Type 0 to avoid displaying or printing the Toxic Species. Type any other number to determine the sequence number that will be used for displaying or printing the Toxic Species. | |
| TOXIC_EXPOSURE_SEQ | NUMBER | (2) | If the Print Toxic Information Flag is set to Y, the Toxic Exposure Sequence will be available. Type 0 to avoid displaying or printing theToxic Exposure. Type any other number to determine the sequence number that will be used for displaying or printing the Toxic Exposure. | |
| TOXIC_DOSE_SEQ | NUMBER | (2) | If the Print Toxic Information Flag is set to Y, the Toxic Dose Sequence will be available. Type 0 to avoid displaying or printing the Toxic Dose. Type any other number to determine the sequence number that will be used for displaying or printing the Toxic Dose. | |
| TOXIC_NOTE_SEQ | NUMBER | (2) | If the Print Toxic Information Flag is set to Y, the Toxic Note Sequence will be available. Type 0 to avoid displaying or printing the Toxic Note. Type any other number to determine the sequence number that will be used for displaying or printing the Toxic Note. | |
| PRINT_EXPOSURE_FLAG | VARCHAR2 | (1) | Yes | Y or N to indicate whether Exposure Limit information will be displayed or printed on the document. |
| EXPOSURE_HEADER_LABEL | VARCHAR2 | (30) | If the Print Exposure Flag is set to Y, the Exposure Header Label will be available. The Exposure Header Label identifies the heading label where the Exposure information will display or print. | |
| EXPOSURE_CAS_NUMBER_SEQ | NUMBER | (2) | If the Print Exposure Flag is set to Y, the Exposure CAS Number Sequence will be available. Type 0 to avoid displaying or printing the CAS Number. Type any other number to determine the numerical sequence number that will be used for displaying or printing the CAS Number. | |
| EXPOSURE_MSDS_NAME_SEQ | NUMBER | (2) | If the Print Exposure Flag is set to Y, the Exposure MSDS Name Sequence will be available. Type 0 to avoid displaying or printing the MSDS Name. Type any other number to determine the numerical sequence number that will be used for displaying or printing the MSDS Name. | |
| EXPOSURE_AUTHORITY_SEQ | NUMBER | (2) | If the Print Exposure Flag is set to Y, the Exposure Authority Sequence will be available. Type 0 to avoid displaying or printing the Exposure Limit Information. Type any other number to determine the numerical sequence number that will be used for displaying or printing the Exposure Limit Information. | |
| EXPOSURE_TYPE_SEQ | NUMBER | (2) | If the Print Exposure Flag is set to Y, the Exposure Type Sequence will be available. Type 0 to avoid displaying or printing the Exposure Type. Type any other number to determine the numerical sequence number that will be used for displaying or printing the Exposure Type. | |
| EXPOSURE_DOSE_SEQ | NUMBER | (2) | If the Print Exposure Flag is set to Y, the Exposure Dose Sequence will be available. Type 0 to avoid displaying or printing the Exposure Dose. Type any other number to determine the numerical sequence number that will be used for displaying or printing the Exposure Dose. | |
| EXPOSURE_NOTE_SEQ | NUMBER | (2) | If the Print Exposure Flag is set to Y, the Exposure Note Sequence will be available. Type 0 to avoid displaying or printing the Exposure Note. Type any other number to determine the numerical sequence number that will be used for displaying or printing the Exposure Note. | |
| INCLUDE_QC_DATA_FLAG | VARCHAR2 | (1) | Y or N to indicate whether OPM Quality Control module data will be used. | |
| PROP_65_CONC_IND | VARCHAR2 | (1) | Y or N to indicate whether the Proposition 65 Concentration warning requirements will be displayed or printed on the document. | |
| SARA_312_CONC_IND | VARCHAR2 | (1) | Y or N to indicate whether the SARA 312 Concentration emergency cleanup requirements will be displayed or printed on the document. | |
| PRINT_RTK_ON_DOCUMENT | VARCHAR2 | (1) | Y or N to indicate whether the RTK (Right-To-Know) information will be displayed or printed on the document. | |
| RTK_HEADER | VARCHAR2 | (32) | If the Print RTK on Document Flag is set to Y, the RTK Header will be available. The RTK Header identifies the heading where the RTK information will display or print. | |
| PRINT_ALL_STATE_INDICATOR | VARCHAR2 | (1) | Y or N to indicate whether to display or print documents for all required states. | |
| APPROVAL_PROCESS_FLAG | VARCHAR2 | (1) | Yes | Y or N to indicate whether the document is workflow controlled. |
| 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 | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
| ATTRIBUTE12 | 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 DOCUMENT_CODE
, USER_ID
, DOCUMENT_VERSION
, DOCUMENT_DESCRIPTION
, DOCUMENT_HISTORY_FLAG
, ALLOW_USER_OVERRIDE
, DOCUMENT_DATE_FORMAT
, PRINT_INGREDIENTS_FLAG
, INGREDIENT_HEADER_LABEL
, INGREDIENT_CONC_IND
, CAS_NUMBER_SEQ
, MSDS_NAME_SEQ
, CONCENTRATION_SEQ
, HMIS_CODE_SEQ
, NFPA_CODE_SEQ
, USER_CODE_SEQ
, EEC_NUMBER_SEQ
, HAZARD_SYMBOL_SEQ
, RISK_PHRASE_SEQ
, SAFETY_PHRASE_SEQ
, PRINT_TOXIC_INFO_FLAG
, TOXIC_HEADER_LABEL
, TOXIC_CAS_NUMBER_SEQ
, TOXIC_MSDS_NAME_SEQ
, TOXIC_ROUTE_SEQ
, TOXIC_SPECIES_SEQ
, TOXIC_EXPOSURE_SEQ
, TOXIC_DOSE_SEQ
, TOXIC_NOTE_SEQ
, PRINT_EXPOSURE_FLAG
, EXPOSURE_HEADER_LABEL
, EXPOSURE_CAS_NUMBER_SEQ
, EXPOSURE_MSDS_NAME_SEQ
, EXPOSURE_AUTHORITY_SEQ
, EXPOSURE_TYPE_SEQ
, EXPOSURE_DOSE_SEQ
, EXPOSURE_NOTE_SEQ
, INCLUDE_QC_DATA_FLAG
, PROP_65_CONC_IND
, SARA_312_CONC_IND
, PRINT_RTK_ON_DOCUMENT
, RTK_HEADER
, PRINT_ALL_STATE_INDICATOR
, APPROVAL_PROCESS_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE13
, ATTRIBUTE12
, 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_DOCUMENT_CODES;
GR.GR_DOCUMENT_CODES does not reference any database object
GR.GR_DOCUMENT_CODES is referenced by following:
APPS
GR_DOCUMENT_CODES
|
|
|
|