VIEW: APPS.IGS_PE_HLTH_INS_V

Source

View Text - Preformatted

SELECT HI.ROWID ROW_ID, HI.HEALTH_INS_ID, HI.person_id, HI.INSURANCE_cd, L1.meaning insurance_type, HI.INSURANCE_PROVIDER, HI.POLICY_NUMBER, HI.START_DATE, HI.END_DATE, HI.CREATED_BY, HI.CREATION_DATE, HI.LAST_UPDATED_BY, HI.LAST_UPDATE_DATE, HI.LAST_UPDATE_LOGIN, HI.ATTRIBUTE_CATEGORY, HI.ATTRIBUTE1, HI.ATTRIBUTE2, HI.ATTRIBUTE3, HI.ATTRIBUTE4, HI.ATTRIBUTE5, HI.ATTRIBUTE6, HI.ATTRIBUTE7, HI.ATTRIBUTE8, HI.ATTRIBUTE9, HI.ATTRIBUTE10, HI.ATTRIBUTE11, HI.ATTRIBUTE12, HI.ATTRIBUTE13, HI.ATTRIBUTE14, HI.ATTRIBUTE15, HI.ATTRIBUTE16, HI.ATTRIBUTE17, HI.ATTRIBUTE18, HI.ATTRIBUTE19, HI.ATTRIBUTE20 FROM IGS_PE_HLTH_INS_ALL HI, IGS_LOOKUP_VALUES L1 WHERE HI. INSURANCE_CD = L1.lookup_code AND L1.lookup_type = 'PE_INS_TYPE'

View Text - HTML Formatted

SELECT HI.ROWID ROW_ID
, HI.HEALTH_INS_ID
, HI.PERSON_ID
, HI.INSURANCE_CD
, L1.MEANING INSURANCE_TYPE
, HI.INSURANCE_PROVIDER
, HI.POLICY_NUMBER
, HI.START_DATE
, HI.END_DATE
, HI.CREATED_BY
, HI.CREATION_DATE
, HI.LAST_UPDATED_BY
, HI.LAST_UPDATE_DATE
, HI.LAST_UPDATE_LOGIN
, HI.ATTRIBUTE_CATEGORY
, HI.ATTRIBUTE1
, HI.ATTRIBUTE2
, HI.ATTRIBUTE3
, HI.ATTRIBUTE4
, HI.ATTRIBUTE5
, HI.ATTRIBUTE6
, HI.ATTRIBUTE7
, HI.ATTRIBUTE8
, HI.ATTRIBUTE9
, HI.ATTRIBUTE10
, HI.ATTRIBUTE11
, HI.ATTRIBUTE12
, HI.ATTRIBUTE13
, HI.ATTRIBUTE14
, HI.ATTRIBUTE15
, HI.ATTRIBUTE16
, HI.ATTRIBUTE17
, HI.ATTRIBUTE18
, HI.ATTRIBUTE19
, HI.ATTRIBUTE20
FROM IGS_PE_HLTH_INS_ALL HI
, IGS_LOOKUP_VALUES L1
WHERE HI. INSURANCE_CD = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'PE_INS_TYPE'