VIEW: APPS.IGF_AW_AWD_LD_CAL_V

Source

View Text - Preformatted

SELECT AW.ROW_ID, AW.CAL_TYPE, AW.SEQUENCE_NUMBER, AW.ALTERNATE_CODE, AW.START_DT, AW.END_DT, LD.CAL_TYPE, LD.SEQUENCE_NUMBER, LD.ALTERNATE_CODE, LD.START_DT, LD.END_DT FROM IGS_CA_INST AW, IGS_CA_INST LD, IGS_CA_TYPE LD_T, IGS_CA_TYPE AW_T, IGS_CA_INST_REL REL WHERE REL.SUP_CAL_TYPE=AW.CAL_TYPE AND REL.SUP_CI_SEQUENCE_NUMBER=AW.SEQUENCE_NUMBER AND REL.SUB_CAL_TYPE=LD.CAL_TYPE AND REL.SUB_CI_SEQUENCE_NUMBER=LD.SEQUENCE_NUMBER AND AW.CAL_TYPE = AW_T.CAL_TYPE AND AW_T.S_CAL_CAT='AWARD' AND LD.CAL_TYPE = LD_T.CAL_TYPE AND LD_T.S_CAL_CAT='LOAD'

View Text - HTML Formatted

SELECT AW.ROW_ID
, AW.CAL_TYPE
, AW.SEQUENCE_NUMBER
, AW.ALTERNATE_CODE
, AW.START_DT
, AW.END_DT
, LD.CAL_TYPE
, LD.SEQUENCE_NUMBER
, LD.ALTERNATE_CODE
, LD.START_DT
, LD.END_DT
FROM IGS_CA_INST AW
, IGS_CA_INST LD
, IGS_CA_TYPE LD_T
, IGS_CA_TYPE AW_T
, IGS_CA_INST_REL REL
WHERE REL.SUP_CAL_TYPE=AW.CAL_TYPE
AND REL.SUP_CI_SEQUENCE_NUMBER=AW.SEQUENCE_NUMBER
AND REL.SUB_CAL_TYPE=LD.CAL_TYPE
AND REL.SUB_CI_SEQUENCE_NUMBER=LD.SEQUENCE_NUMBER
AND AW.CAL_TYPE = AW_T.CAL_TYPE
AND AW_T.S_CAL_CAT='AWARD'
AND LD.CAL_TYPE = LD_T.CAL_TYPE
AND LD_T.S_CAL_CAT='LOAD'