VIEW: APPS.GR_DOCUMENT_CODES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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