VIEW: APPS.IGS_SV_EV_SHRT_PRG_BLK_V

Source

View Text - Preformatted

SELECT prgm.batch_id batch_id, prgm.person_id person_id, prgm.end_prgm_reason short_program_reason, prgm.PRGM_END_DATE new_prg_end_date, prgm.remarks short_program_remarks FROM igs_sv_prgms_info prgm WHERE prgm.prgm_action_type = 'SP'

View Text - HTML Formatted

SELECT PRGM.BATCH_ID BATCH_ID
, PRGM.PERSON_ID PERSON_ID
, PRGM.END_PRGM_REASON SHORT_PROGRAM_REASON
, PRGM.PRGM_END_DATE NEW_PRG_END_DATE
, PRGM.REMARKS SHORT_PROGRAM_REMARKS
FROM IGS_SV_PRGMS_INFO PRGM
WHERE PRGM.PRGM_ACTION_TYPE = 'SP'