[Home] [Help]
VIEW: APPS.IGS_DA_XML_DEGREEPROGRAM_V
Source
View Text - Preformatted
SELECT DISTINCT drs.batch_id, hp.party_number, drs.person_id FROM hz_parties hp, igs_da_req_stdnts drs WHERE drs.report_text IS NULL
View Text - HTML Formatted
SELECT DISTINCT DRS.BATCH_ID
, HP.PARTY_NUMBER
, DRS.PERSON_ID
FROM HZ_PARTIES HP
, IGS_DA_REQ_STDNTS DRS
WHERE DRS.REPORT_TEXT IS NULL