[Home] [Help]
VIEW: APPS.IGS_DA_XML_TRANSACTION_TYPE_V
Source
View Text - Preformatted
SELECT distinct dcrt.request_type, dr.batch_id from igs_da_rqst dr, igs_da_cnfg_req_typ dcrt WHERE dr.request_type_id = dcrt.request_type_id
View Text - HTML Formatted
SELECT DISTINCT DCRT.REQUEST_TYPE
, DR.BATCH_ID
FROM IGS_DA_RQST DR
, IGS_DA_CNFG_REQ_TYP DCRT
WHERE DR.REQUEST_TYPE_ID = DCRT.REQUEST_TYPE_ID