VIEW: APPS.IGS_DA_OUT_RQST_FTR_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')