VIEW: APPS.IGF_AW_TERM_MAP_V

Source

View Text - Preformatted

SELECT TMAP.ROW_ID , TMAP.TMAP_ID , TMAP.EXT_TERM , TMAP.CI_CAL_TYPE, TMAP.CI_SEQUENCE_NUMBER , CI.ALTERNATE_CODE , CI.START_DT , CI.END_DT , TMAP.LD_CAL_TYPE , TMAP.LD_SEQUENCE_NUMBER , LD.ALTERNATE_CODE , LD.START_DT , LD.END_DT , TMAP.ACTIVE , TMAP.CREATED_BY , TMAP.CREATION_DATE , TMAP.LAST_UPDATED_BY , TMAP.LAST_UPDATE_DATE , TMAP.LAST_UPDATE_LOGIN FROM IGF_AW_TERM_MAP TMAP , IGS_CA_INST CI , IGS_CA_INST LD WHERE TMAP.LD_CAL_TYPE = LD.CAL_TYPE AND TMAP.LD_SEQUENCE_NUMBER =LD.SEQUENCE_NUMBER AND TMAP.CI_CAL_TYPE = CI.CAL_TYPE AND TMAP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT TMAP.ROW_ID
, TMAP.TMAP_ID
, TMAP.EXT_TERM
, TMAP.CI_CAL_TYPE
, TMAP.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, TMAP.LD_CAL_TYPE
, TMAP.LD_SEQUENCE_NUMBER
, LD.ALTERNATE_CODE
, LD.START_DT
, LD.END_DT
, TMAP.ACTIVE
, TMAP.CREATED_BY
, TMAP.CREATION_DATE
, TMAP.LAST_UPDATED_BY
, TMAP.LAST_UPDATE_DATE
, TMAP.LAST_UPDATE_LOGIN
FROM IGF_AW_TERM_MAP TMAP
, IGS_CA_INST CI
, IGS_CA_INST LD
WHERE TMAP.LD_CAL_TYPE = LD.CAL_TYPE
AND TMAP.LD_SEQUENCE_NUMBER =LD.SEQUENCE_NUMBER
AND TMAP.CI_CAL_TYPE = CI.CAL_TYPE
AND TMAP.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER