VIEW: APPS.IGS_GR_GRD_PERD_V

Source

View Text - Preformatted

SELECT UNIQUE RPAD(CRD.GRD_CAL_TYPE, 10) || RPAD(TO_CHAR(CRD.GRD_CI_SEQUENCE_NUMBER),10) GRD_PERD, RPAD(NVL(CI.ALTERNATE_CODE, CI.CAL_TYPE), 10) ALT_CODE, TO_CHAR(CI.START_DT, 'DD/MM/YYYY') START_DT, RPAD(TO_CHAR(CI.END_DT, 'DD/MM/YYYY'), 20) END_DT 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'

View Text - HTML Formatted

SELECT UNIQUE RPAD(CRD.GRD_CAL_TYPE
, 10) || RPAD(TO_CHAR(CRD.GRD_CI_SEQUENCE_NUMBER)
, 10) GRD_PERD
, RPAD(NVL(CI.ALTERNATE_CODE
, CI.CAL_TYPE)
, 10) ALT_CODE
, TO_CHAR(CI.START_DT
, 'DD/MM/YYYY') START_DT
, RPAD(TO_CHAR(CI.END_DT
, 'DD/MM/YYYY')
, 20) END_DT
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'