View: IGS_GR_GRD_PERD_ABBRVTN_V

View Text

SELECT UNIQUE RPAD(CRD.GRD_CAL_TYPE
, 10) || RPAD(TO_CHAR(CRD.GRD_CI_SEQUENCE_NUMBER)
, 10) || RPAD('%'
, 3) GRD_PERD
, RPAD(NVL(CI.ALTERNATE_CODE
, CI.CAL_TYPE)
, 10) ALT_CODE
, TO_CHAR(CI.START_DT
, 'DD/MM/YYYY') START_DT
, TO_CHAR(CI.END_DT
, 'DD/MM/YYYY') END_DT
, RPAD(NVL(CAT.ABBREVIATION
, ' ')
, 30) ABBRVTN
FROM IGS_GR_CRMN_ROUND CRD
, IGS_GR_CRMN GC
, IGS_CA_INST CI
, IGS_CA_TYPE CAT
, IGS_CA_STAT CS
WHERE CRD.GRD_CAL_TYPE = CI.CAL_TYPE
AND CRD.GRD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CRD.GRD_CAL_TYPE = GC.GRD_CAL_TYPE
AND CRD.GRD_CI_SEQUENCE_NUMBER = GC.GRD_CI_SEQUENCE_NUMBER
AND CI.CAL_TYPE = CAT.CAL_TYPE
AND CI.CAL_STATUS = CS.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'

Columns