VIEW: APPS.IGF_SL_PE_CITI_MAP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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