VIEW: APPS.PA_RBS_VERSIONS_OLAP_V

Source

View Text - Preformatted

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') = 'N' 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') = 'N' UNION ALL SELECT - 1
, -1
FROM DUAL