SELECT b.rbs_version_id , b.olap_element_id from pa_rbs_versions_b b , pa_rbs_headers_b d WHERE b.rbs_header_id = d.rbs_header_id and nvl(d.cbs_enabled,'N') = 'Y' union all select - 1, -1 from dual
View Text - HTML Formatted
SELECT B.RBS_VERSION_ID , B.OLAP_ELEMENT_ID FROM PA_RBS_VERSIONS_B B , PA_RBS_HEADERS_B D WHERE B.RBS_HEADER_ID = D.RBS_HEADER_ID AND NVL(D.CBS_ENABLED , 'N') = 'Y' UNION ALL SELECT - 1 , -1 FROM DUAL