VIEW: APPS.IGF_AW_CAL_REL_V

Source

View Text - Preformatted

SELECT CREL.ROW_ID , CREL.CREL_ID , CREL.CR_CAL_TYPE , CREL.CR_SEQUENCE_NUMBER , CR_CI.ALTERNATE_CODE , CR_CI.START_DT , CR_CI.END_DT , CREL.CR_CAL_TYPE , CREL.SC_SEQUENCE_NUMBER , SC_CI.ALTERNATE_CODE , SC_CI.START_DT , SC_CI.END_DT , CREL.ACTIVE , CREL.CREATED_BY , CREL.CREATION_DATE , CREL.LAST_UPDATED_BY, CREL.LAST_UPDATE_DATE , CREL.LAST_UPDATE_LOGIN FROM IGF_AW_CAL_REL CREL , IGS_CA_INST CR_CI , IGS_CA_INST SC_CI WHERE CREL.CR_CAL_TYPE = CR_CI.CAL_TYPE AND CREL.CR_SEQUENCE_NUMBER = CR_CI.SEQUENCE_NUMBER AND CREL.CR_CAL_TYPE = SC_CI.CAL_TYPE AND CREL.SC_SEQUENCE_NUMBER = SC_CI.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT CREL.ROW_ID
, CREL.CREL_ID
, CREL.CR_CAL_TYPE
, CREL.CR_SEQUENCE_NUMBER
, CR_CI.ALTERNATE_CODE
, CR_CI.START_DT
, CR_CI.END_DT
, CREL.CR_CAL_TYPE
, CREL.SC_SEQUENCE_NUMBER
, SC_CI.ALTERNATE_CODE
, SC_CI.START_DT
, SC_CI.END_DT
, CREL.ACTIVE
, CREL.CREATED_BY
, CREL.CREATION_DATE
, CREL.LAST_UPDATED_BY
, CREL.LAST_UPDATE_DATE
, CREL.LAST_UPDATE_LOGIN
FROM IGF_AW_CAL_REL CREL
, IGS_CA_INST CR_CI
, IGS_CA_INST SC_CI
WHERE CREL.CR_CAL_TYPE = CR_CI.CAL_TYPE
AND CREL.CR_SEQUENCE_NUMBER = CR_CI.SEQUENCE_NUMBER
AND CREL.CR_CAL_TYPE = SC_CI.CAL_TYPE
AND CREL.SC_SEQUENCE_NUMBER = SC_CI.SEQUENCE_NUMBER