VIEW: APPS.IGSFV_MILITARY_SERVICES

Source

View Text - Preformatted

SELECT HZP.PARTY_NUMBER, '_LA:PMS.MILITARY_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_SEV_TYPE:MEANING', PMS.START_DATE, PMS.END_DATE, '_LA:PMS.SEPARATION_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_SEP_TYPE:MEANING', '_LA:PMS.ASSISTANCE_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_ASS_TYPE:MEANING', '_LA:PMS.ASSISTANCE_STATUS_CD:IGS_LOOKUP_VALUES:PE_MIL_ASS_STATUS:MEANING', '_DF:IGS:IGS_PE_MIL_SERVICE_FLEX:PMS', PMS.MILIT_SERVICE_ID, PMS.PERSON_ID, PMS.CREATED_BY, PMS.CREATION_DATE, PMS.LAST_UPDATED_BY, PMS.LAST_UPDATE_DATE FROM IGS_PE_MIL_SERVICES_ALL PMS, HZ_PARTIES HZP WHERE PMS.PERSON_ID=HZP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT HZP.PARTY_NUMBER
, '_LA:PMS.MILITARY_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_SEV_TYPE:MEANING'
, PMS.START_DATE
, PMS.END_DATE
, '_LA:PMS.SEPARATION_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_SEP_TYPE:MEANING'
, '_LA:PMS.ASSISTANCE_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_ASS_TYPE:MEANING'
, '_LA:PMS.ASSISTANCE_STATUS_CD:IGS_LOOKUP_VALUES:PE_MIL_ASS_STATUS:MEANING'
, '_DF:IGS:IGS_PE_MIL_SERVICE_FLEX:PMS'
, PMS.MILIT_SERVICE_ID
, PMS.PERSON_ID
, PMS.CREATED_BY
, PMS.CREATION_DATE
, PMS.LAST_UPDATED_BY
, PMS.LAST_UPDATE_DATE
FROM IGS_PE_MIL_SERVICES_ALL PMS
, HZ_PARTIES HZP
WHERE PMS.PERSON_ID=HZP.PARTY_ID WITH READ ONLY