DBA Data[Home] [Help]

VIEW: APPS.IGS_SV_CNCL_STDNT_BLK_V

Source

View Text - Preformatted

SELECT prgms.batch_id, prgms.person_id, prgms.termination_reason cancel_reason, prgms.remarks cancel_remarks FROM igs_sv_prgms_info prgms WHERE prgms.prgm_action_type = 'CP'
View Text - HTML Formatted

SELECT PRGMS.BATCH_ID
, PRGMS.PERSON_ID
, PRGMS.TERMINATION_REASON CANCEL_REASON
, PRGMS.REMARKS CANCEL_REMARKS
FROM IGS_SV_PRGMS_INFO PRGMS
WHERE PRGMS.PRGM_ACTION_TYPE = 'CP'