Product: | GR - Process Manufacturing Regulatory Management |
---|---|
Description: | Contains the rows for the document code |
Implementation/DBA Data: | APPS.GR_DOCUMENT_CODES_V |
SELECT D.ROWID ROW_ID
, D.DOCUMENT_CODE
, D.USER_ID
, F.USER_NAME
, F.DESCRIPTION
, D.DOCUMENT_VERSION
, D.DOCUMENT_DESCRIPTION
, D.DOCUMENT_HISTORY_FLAG
, D.ALLOW_USER_OVERRIDE
, D.DOCUMENT_DATE_FORMAT
, D.PRINT_INGREDIENTS_FLAG
, D.INGREDIENT_HEADER_LABEL
, D.INGREDIENT_CONC_IND
, D.CAS_NUMBER_SEQ
, D.MSDS_NAME_SEQ
, D.CONCENTRATION_SEQ
, D.HMIS_CODE_SEQ
, D.NFPA_CODE_SEQ
, D.USER_CODE_SEQ
, D.EEC_NUMBER_SEQ
, D.HAZARD_SYMBOL_SEQ
, D.RISK_PHRASE_SEQ
, D.SAFETY_PHRASE_SEQ
, D.PRINT_TOXIC_INFO_FLAG
, D.TOXIC_HEADER_LABEL
, D.TOXIC_CAS_NUMBER_SEQ
, D.TOXIC_MSDS_NAME_SEQ
, D.TOXIC_ROUTE_SEQ
, D.TOXIC_SPECIES_SEQ
, D.TOXIC_EXPOSURE_SEQ
, D.TOXIC_DOSE_SEQ
, D.TOXIC_NOTE_SEQ
, D.PRINT_EXPOSURE_FLAG
, D.EXPOSURE_HEADER_LABEL
, D.EXPOSURE_CAS_NUMBER_SEQ
, D.EXPOSURE_MSDS_NAME_SEQ
, D.EXPOSURE_AUTHORITY_SEQ
, D.EXPOSURE_TYPE_SEQ
, D.EXPOSURE_DOSE_SEQ
, D.EXPOSURE_NOTE_SEQ
, D.INCLUDE_QC_DATA_FLAG
, D.PROP_65_CONC_IND
, D.SARA_312_CONC_IND
, D.PRINT_RTK_ON_DOCUMENT
, D.RTK_HEADER
, D.PRINT_ALL_STATE_INDICATOR
, D.APPROVAL_PROCESS_FLAG
, D.ATTRIBUTE_CATEGORY
, D.ATTRIBUTE1
, D.ATTRIBUTE2
, D.ATTRIBUTE3
, D.ATTRIBUTE4
, D.ATTRIBUTE5
, D.ATTRIBUTE6
, D.ATTRIBUTE7
, D.ATTRIBUTE8
, D.ATTRIBUTE9
, D.ATTRIBUTE10
, D.ATTRIBUTE11
, D.ATTRIBUTE13
, D.ATTRIBUTE12
, D.ATTRIBUTE14
, D.ATTRIBUTE15
, D.ATTRIBUTE16
, D.ATTRIBUTE17
, D.ATTRIBUTE18
, D.ATTRIBUTE19
, D.ATTRIBUTE20
, D.ATTRIBUTE21
, D.ATTRIBUTE22
, D.ATTRIBUTE23
, D.ATTRIBUTE24
, D.ATTRIBUTE25
, D.ATTRIBUTE26
, D.ATTRIBUTE27
, D.ATTRIBUTE28
, D.ATTRIBUTE29
, D.ATTRIBUTE30
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATE_LOGIN
FROM GR_DOCUMENT_CODES D
, FND_USER F
WHERE D.USER_ID = F.USER_ID