VIEW: APPS.IGS_PR_RUL_OUTAPPL_V

Source

View Text - Preformatted

SELECT rpad(rpad(igs_en_gen_014.enrs_get_acad_alt_cd (ci.cal_type,ci.sequence_number)||'/'|| nvl(ci.alternate_code,ci.cal_type),21)||''|| to_char(ci.start_dt,'DD/MM/YYYY')||'-'|| to_char(ci.end_dt,'DD/MM/YYYY')||''||ct.abbreviation,100)|| rpad(ci.cal_type,10)||to_char(ci.sequence_number,'999990') prgcal ,ci.start_dt,ci.end_dt from igs_ca_inst ci,igs_ca_type ct,igs_ca_stat cs WHERE ci.cal_type=ct.cal_type and ct.s_cal_cat ='PROGRESS' and ci.cal_status=cs.cal_status and cs.s_cal_status='ACTIVE'

View Text - HTML Formatted

SELECT RPAD(RPAD(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD (CI.CAL_TYPE
, CI.SEQUENCE_NUMBER)||'/'|| NVL(CI.ALTERNATE_CODE
, CI.CAL_TYPE)
, 21)||''|| TO_CHAR(CI.START_DT
, 'DD/MM/YYYY')||'-'|| TO_CHAR(CI.END_DT
, 'DD/MM/YYYY')||''||CT.ABBREVIATION
, 100)|| RPAD(CI.CAL_TYPE
, 10)||TO_CHAR(CI.SEQUENCE_NUMBER
, '999990') PRGCAL
, CI.START_DT
, CI.END_DT
FROM IGS_CA_INST CI
, IGS_CA_TYPE CT
, IGS_CA_STAT CS
WHERE CI.CAL_TYPE=CT.CAL_TYPE
AND CT.S_CAL_CAT ='PROGRESS'
AND CI.CAL_STATUS=CS.CAL_STATUS
AND CS.S_CAL_STATUS='ACTIVE'