View: IGF_SL_PE_CITI_MAP_V

Product:	IGF - Financial Aid
Description:	View for the OSS and FA data mapping for Citizenship Code
Implementation/DBA Data:	APPS.IGF_SL_PE_CITI_MAP_V

View Text

SELECT CITIMAP.ROWID
, CITIMAP.CI_CAL_TYPE
, CITIMAP.CI_SEQUENCE_NUMBER
, CA.START_DT
, CA.END_DT
, CA.ALTERNATE_CODE
, CITIMAP.PE_CITI_STAT_CODE
, IGS.MEANING
, CITIMAP.FA_CITI_STAT_CODE
, IGF.MEANING
, CITIMAP.CREATED_BY
, CITIMAP.CREATION_DATE
, CITIMAP.LAST_UPDATED_BY
, CITIMAP.LAST_UPDATE_DATE
, CITIMAP.LAST_UPDATE_LOGIN
FROM IGF_SL_PE_CITI_MAP CITIMAP
, IGS_LOOKUPS_VIEW IGS
, IGF_LOOKUPS_VIEW IGF
, IGS_CA_INST CA
WHERE IGS.LOOKUP_TYPE = 'PE_CITI_STATUS'
AND IGF.LOOKUP_TYPE = 'IGF_SL_PE_CITI_STATUS'
AND IGS.LOOKUP_CODE = CITIMAP.PE_CITI_STAT_CODE
AND IGF.LOOKUP_CODE = CITIMAP.FA_CITI_STAT_CODE
AND CA.CAL_TYPE = CITIMAP.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = CITIMAP.CI_SEQUENCE_NUMBER

Columns