VIEW: APPS.IGS_SV_EXT_PRGM_BLK_V

Source

View Text - Preformatted

SELECT prgms.batch_id, prgms.person_id, prgms.print_form, prgms.prgm_end_date new_prgm_end_date, prgms.remarks EP_remarks, prgms.remarks explanation FROM igs_sv_prgms_info prgms WHERE prgms.prgm_action_type = 'E'

View Text - HTML Formatted

SELECT PRGMS.BATCH_ID
, PRGMS.PERSON_ID
, PRGMS.PRINT_FORM
, PRGMS.PRGM_END_DATE NEW_PRGM_END_DATE
, PRGMS.REMARKS EP_REMARKS
, PRGMS.REMARKS EXPLANATION
FROM IGS_SV_PRGMS_INFO PRGMS
WHERE PRGMS.PRGM_ACTION_TYPE = 'E'