VIEW: APPS.IGS_PE_MIL_SERVICE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'