View: IGS_PE_MIL_SERVICE_V

View Text

SELECT MS.ROWID ROW_ID
, MS. MILIT_SERVICE_ID
, MS.PERSON_ID
, CC1.MEANING SERVICE_TYPE
, MS.MILITARY_TYPE_CD
, MS.START_DATE
, MS.END_DATE
, CC2.MEANING SEPARATION_TYPE
, MS.SEPARATION_TYPE_CD
, CC3.MEANING ASSISTANCE_TYPE
, MS.ASSISTANCE_TYPE_CD
, CC4.MEANING ASSISTANCE_STATUS
, MS.ASSISTANCE_STATUS_CD
, MS.ATTRIBUTE_CATEGORY
, MS.ATTRIBUTE1
, MS.ATTRIBUTE2
, MS.ATTRIBUTE3
, MS.ATTRIBUTE4
, MS.ATTRIBUTE5
, MS.ATTRIBUTE6
, MS.ATTRIBUTE7
, MS.ATTRIBUTE8
, MS.ATTRIBUTE9
, MS.ATTRIBUTE10
, MS.ATTRIBUTE11
, MS.ATTRIBUTE12
, MS.ATTRIBUTE13
, MS.ATTRIBUTE14
, MS.ATTRIBUTE15
, MS.ATTRIBUTE16
, MS.ATTRIBUTE17
, MS.ATTRIBUTE18
, MS.ATTRIBUTE19
, MS.ATTRIBUTE20
, MS.CREATED_BY
, MS.CREATION_DATE
, MS.LAST_UPDATED_BY
, MS.LAST_UPDATE_DATE
, MS.LAST_UPDATE_LOGIN FROM IGS_PE_MIL_SERVICES MS
, IGS_LOOKUP_VALUES CC1
, IGS_LOOKUP_VALUES CC2
, IGS_LOOKUP_VALUES CC3
, IGS_LOOKUP_VALUES CC4
WHERE CC1.LOOKUP_CODE = MS.MILITARY_TYPE_CD
AND CC1.LOOKUP_TYPE = 'PE_MIL_SEV_TYPE'
AND CC2.LOOKUP_CODE(+) = MS.SEPARATION_TYPE_CD
AND CC2.LOOKUP_TYPE(+) = 'PE_MIL_SEP_TYPE'
AND CC3.LOOKUP_CODE(+) = MS.ASSISTANCE_TYPE_CD
AND CC3.LOOKUP_TYPE(+) = 'PE_MIL_ASS_TYPE'
AND CC4.LOOKUP_CODE(+) = MS.ASSISTANCE_STATUS_CD
AND CC4.LOOKUP_TYPE(+) = 'PE_MIL_ASS_STATUS'

Columns