Product: | IGS - Student System (Obsolete) |
---|---|
Description: | XML element ControlType. View of the request configuration. Provides 3rd Party Software specific processing instructions. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DR.BATCH_ID
, HP.PARTY_NUMBER
, (SELECT TO_CHAR(TO_DATE(DRF.FEATURE_VALUE
, 'YYYY-MM-DD')
, 'YYYY-MM-DD')
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'DAT'
AND DRF.BATCH_ID = DR.BATCH_ID)
, (SELECT TO_CHAR(TO_DATE(DRF.FEATURE_VALUE
, 'YYYY-MM-DD')
, 'HH24:MI:SS')
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'DAT'
AND DRF.BATCH_ID = DR.BATCH_ID)
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'SRV'
AND DRF.BATCH_ID = DR.BATCH_ID)
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'COM'
AND DRF.BATCH_ID = DR.BATCH_ID)
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'PNT'
AND DRF.BATCH_ID = DR.BATCH_ID)
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'SZE'
AND DRF.BATCH_ID = DR.BATCH_ID)
, NVL ( (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'RPT'
AND DRF.BATCH_ID = DR.BATCH_ID)
, ' ')
, NVL ( (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'RQT'
AND DRF.BATCH_ID = DR.BATCH_ID)
, ' ') REQUEST_TYPE
, ''
, ''
, ''
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'LIN'
AND DRF.BATCH_ID = DR.BATCH_ID)
, DECODE((SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'DMP'
AND DRF.BATCH_ID = DR.BATCH_ID)
, 'Y'
, 'TRUE'
, 'FALSE')
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'DPM'
AND DRF.BATCH_ID = DR.BATCH_ID)
, (SELECT DRF.FEATURE_VALUE
FROM IGS_DA_REQ_FTRS DRF
WHERE DRF.FEATURE_CODE = 'FMT'
AND DRF.BATCH_ID = DR.BATCH_ID)
, DR.BATCH_ID
, HP1.PARTY_NUMBER
FROM IGS_DA_RQST DR
, IGS_DA_CNFG_REQ_TYP DCRT
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
, HZ_PARTIES HP1
WHERE DR.REQUESTOR_ID = HP.PARTY_ID
AND DR.REQUEST_TYPE_ID = DCRT.REQUEST_TYPE_ID
AND IHP.OI_LOCAL_INSTITUTION_IND = 'Y'
AND HP1.PARTY_ID = IHP.PARTY_ID
AND IHP.INST_ORG_IND = 'I'