View for OKR_RESPONSE_SET_B and OKR_RESPONSE_SET_TL
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT RPST.ID ID , RPST.NAME NAME FROM OKR_RESP_VALUES_TL RPVT , OKR_RESP_VALUES_B RPVB , OKR_PROP_RESP_SET_TL RPST , OKR_PROP_RESP_SET_B RPSB WHERE RPVB.ID = RPVT.ID AND RPVT.LANGUAGE = USERENV('LANG') AND RPVB.RESP_SET_ID = RPST.ID AND RPST.ID = RPSB.ID AND RPST.LANGUAGE = USERENV('LANG') AND SYSDATE BETWEEN NVL(RPVB.START_DATE_ACTIVE , SYSDATE) AND NVL(RPVB.END_DATE_ACTIVE , SYSDATE) AND SYSDATE BETWEEN NVL(RPSB.START_DATE_ACTIVE , SYSDATE) AND NVL(RPSB.END_DATE_ACTIVE , SYSDATE)