VIEW: APPS.IGS_PE_IMMU_DTLS_V

Source

View Text - Preformatted

SELECT IM.ROWID ROW_ID, IM.IMMU_DETAILS_ID, IM.PERSON_ID, IM.IMMUNIZATION_CODE, C1.MEANING IMMUNIZATION_M, IM.STATUS_CODE, C2.MEANING STATUS_M, IM.START_DATE, IM.END_DATE, IM.CREATED_BY, IM.CREATION_DATE, IM.LAST_UPDATED_BY, IM.LAST_UPDATE_DATE, IM.LAST_UPDATE_LOGIN , IM.ATTRIBUTE_CATEGORY, IM.ATTRIBUTE1, IM.ATTRIBUTE2, IM.ATTRIBUTE3, IM.ATTRIBUTE4, IM.ATTRIBUTE5, IM.ATTRIBUTE6, IM.ATTRIBUTE7, IM.ATTRIBUTE8, IM.ATTRIBUTE9, IM.ATTRIBUTE10, IM.ATTRIBUTE11, IM.ATTRIBUTE12, IM.ATTRIBUTE13, IM.ATTRIBUTE14, IM.ATTRIBUTE15, IM.ATTRIBUTE16, IM.ATTRIBUTE17, IM.ATTRIBUTE18, IM.ATTRIBUTE19, IM.ATTRIBUTE20 FROM IGS_PE_IMMU_DTLS IM, igs_lookup_values C1, igs_lookup_values C2 WHERE IM.IMMUNIZATION_CODE = C1.lookup_CODE AND IM.STATUS_CODE = C2.lookup_CODE AND C1.lookup_type = 'PE_IMM_TYPE' AND C2.lookup_type = 'PE_IMM_STATUS'

View Text - HTML Formatted

SELECT IM.ROWID ROW_ID
, IM.IMMU_DETAILS_ID
, IM.PERSON_ID
, IM.IMMUNIZATION_CODE
, C1.MEANING IMMUNIZATION_M
, IM.STATUS_CODE
, C2.MEANING STATUS_M
, IM.START_DATE
, IM.END_DATE
, IM.CREATED_BY
, IM.CREATION_DATE
, IM.LAST_UPDATED_BY
, IM.LAST_UPDATE_DATE
, IM.LAST_UPDATE_LOGIN
, IM.ATTRIBUTE_CATEGORY
, IM.ATTRIBUTE1
, IM.ATTRIBUTE2
, IM.ATTRIBUTE3
, IM.ATTRIBUTE4
, IM.ATTRIBUTE5
, IM.ATTRIBUTE6
, IM.ATTRIBUTE7
, IM.ATTRIBUTE8
, IM.ATTRIBUTE9
, IM.ATTRIBUTE10
, IM.ATTRIBUTE11
, IM.ATTRIBUTE12
, IM.ATTRIBUTE13
, IM.ATTRIBUTE14
, IM.ATTRIBUTE15
, IM.ATTRIBUTE16
, IM.ATTRIBUTE17
, IM.ATTRIBUTE18
, IM.ATTRIBUTE19
, IM.ATTRIBUTE20
FROM IGS_PE_IMMU_DTLS IM
, IGS_LOOKUP_VALUES C1
, IGS_LOOKUP_VALUES C2
WHERE IM.IMMUNIZATION_CODE = C1.LOOKUP_CODE
AND IM.STATUS_CODE = C2.LOOKUP_CODE
AND C1.LOOKUP_TYPE = 'PE_IMM_TYPE'
AND C2.LOOKUP_TYPE = 'PE_IMM_STATUS'