Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view is to be created so that all information about all the feature values that have been defined for the features defined |
Implementation/DBA Data: | Not implemented in this database |
SELECT RQ.ROWID ROW_ID
, RQ.BATCH_ID
, RQ.REQUEST_MODE
, RQ.REQUEST_TYPE
, RQ.REQUEST_TYPE_COM1
, RQ.REQUEST_TYPE_COM2
, RQ.REQUEST_TYPE_COM3
, RQ.REQUEST_TYPE_COM4
, RF.FEATURE_NAME
, RF.FEATURE_VALUE
, RF.DISPLAY_FLAG
, RF.FEATURE_UPDATE_FLAG
, RQ.CREATION_DATE
, RQ.CREATED_BY
, RQ.LAST_UPDATE_LOGIN
, RQ.LAST_UPDATED_BY
, RQ.LAST_UPDATE_DATE
FROM IGS_DA_RQST RQ
, IGS_DA_REQ_FTRS RF
WHERE RQ.BATCH_ID = RF.BATCH_ID
AND RF.FEATURE_NAME NOT IN (SELECT FVM.FEATURE_CODE
FROM IGS_DA_FTR_VAL_MAP FVM
WHERE FVM.THIRD_PARTY_FTR_FLAG = 'N')