[Home] [Help]
489: SELECT uai.ass_id
490: FROM igs_ca_stat cs,
491: igs_ca_inst ci,
492: igs_ps_unit_stat ust,
493: igs_ps_unit_ver uv,
494: igs_as_unitass_item uai
495: WHERE cs.s_cal_status <> 'INACTIVE'
496: AND ci.cal_status = cs.cal_status
497: AND uai.ci_sequence_number = ci.sequence_number