VIEW: APPS.IGS_DA_XML_CONTROLGPA_V

Source

View Text - Preformatted

SELECT dcs.stat_type, dcs.timeframe, NVL( (select drf.feature_value from igs_da_req_ftrs drf WHERE drf.batch_id = dr.batch_id and drf.feature_code = 'TRM'), 'No Session Value'), dr.batch_id from igs_da_rqst dr, igs_da_cnfg_stat dcs where dr.request_type_id = dcs.request_type_id

View Text - HTML Formatted

SELECT DCS.STAT_TYPE
, DCS.TIMEFRAME
, NVL( (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.BATCH_ID = DR.BATCH_ID
AND DRF.FEATURE_CODE = 'TRM')
, 'NO SESSION VALUE')
, DR.BATCH_ID
FROM IGS_DA_RQST DR
, IGS_DA_CNFG_STAT DCS
WHERE DR.REQUEST_TYPE_ID = DCS.REQUEST_TYPE_ID