Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | a view of the approved supply list concentrations |
Implementation/DBA Data: | APPS.GR_EIN_ASL_CONCS_V |
SELECT EAC.ROWID ROW_ID
, EAC.SEQUENCE_NUMBER
, EAC.EUROPEAN_INDEX_NUMBER
, EAC.CONCENTRATION_HIGH
, EAC.CONCENTRATION_LOW
, EAC.CONSOLIDATED_RISK_PHRASE
, EAC.CALCULATION_ID
, EAC.CREATED_BY
, EAC.CREATION_DATE
, EAC.LAST_UPDATED_BY
, EAC.LAST_UPDATE_DATE
, EAC.LAST_UPDATE_LOGIN
, EAC.HAZARD_CLASSIFICATION_CODE
, EHT.HAZARD_DESCRIPTION
FROM GR_EIN_ASL_CONCS EAC
, GR_EUROHAZARDS_TL EHT
WHERE EAC.HAZARD_CLASSIFICATION_CODE = EHT.HAZARD_CLASSIFICATION_CODE (+)
AND EHT.LANGUAGE (+) = USERENV('LANG')