VIEW: APPS.PA_RBS_ELEMENTS_OLAP_V

Source

View Text - Preformatted

SELECT h.rbs_version_id , r.rbs_element_id , nvl(r.parent_element_id, h.rbs_version_id+10000000000 ) parent_element_id from pa_rbs_versions_b h , pa_rbs_elements r , pa_rbs_headers_b d WHERE h.rbs_version_id = r.rbs_version_id and nvl(d.cbs_enabled,'N') = 'N' and d.rbs_header_id = h.rbs_header_id union all select h.rbs_version_id, h.rbs_version_id+10000000000 , 0 from pa_rbs_versions_b h , pa_rbs_headers_b d where nvl(d.cbs_enabled,'N') = 'N' and d.rbs_header_id = h.rbs_header_id union all select -1 , 0 , to_number(null) parent_element_id from dual union all select -1 , -1 , to_number(null) parent_element_id from dual union all select h.rbs_version_id , -1*r.rbs_element_id , r.rbs_element_id parent_element_id from pa_rbs_versions_b h , pa_rbs_elements r , pa_rbs_headers_b d where h.rbs_version_id = r.rbs_version_id and nvl(d.cbs_enabled,'N') = 'N' and d.rbs_header_id = h.rbs_header_id union all select h.rbs_version_id, -1*(h.rbs_version_id+10000000000) , h.rbs_version_id+10000000000 from pa_rbs_versions_b h , pa_rbs_headers_b d where nvl(d.cbs_enabled,'N') = 'N' and d.rbs_header_id = h.rbs_header_id

View Text - HTML Formatted

SELECT H.RBS_VERSION_ID
, R.RBS_ELEMENT_ID
, NVL(R.PARENT_ELEMENT_ID
, H.RBS_VERSION_ID+10000000000 ) PARENT_ELEMENT_ID
FROM PA_RBS_VERSIONS_B H
, PA_RBS_ELEMENTS R
, PA_RBS_HEADERS_B D
WHERE H.RBS_VERSION_ID = R.RBS_VERSION_ID
AND NVL(D.CBS_ENABLED
, 'N') = 'N'
AND D.RBS_HEADER_ID = H.RBS_HEADER_ID UNION ALL SELECT H.RBS_VERSION_ID
, H.RBS_VERSION_ID+10000000000
, 0
FROM PA_RBS_VERSIONS_B H
, PA_RBS_HEADERS_B D
WHERE NVL(D.CBS_ENABLED
, 'N') = 'N'
AND D.RBS_HEADER_ID = H.RBS_HEADER_ID UNION ALL SELECT -1
, 0
, TO_NUMBER(NULL) PARENT_ELEMENT_ID
FROM DUAL UNION ALL SELECT -1
, -1
, TO_NUMBER(NULL) PARENT_ELEMENT_ID
FROM DUAL UNION ALL SELECT H.RBS_VERSION_ID
, -1*R.RBS_ELEMENT_ID
, R.RBS_ELEMENT_ID PARENT_ELEMENT_ID
FROM PA_RBS_VERSIONS_B H
, PA_RBS_ELEMENTS R
, PA_RBS_HEADERS_B D
WHERE H.RBS_VERSION_ID = R.RBS_VERSION_ID
AND NVL(D.CBS_ENABLED
, 'N') = 'N'
AND D.RBS_HEADER_ID = H.RBS_HEADER_ID UNION ALL SELECT H.RBS_VERSION_ID
, -1*(H.RBS_VERSION_ID+10000000000)
, H.RBS_VERSION_ID+10000000000
FROM PA_RBS_VERSIONS_B H
, PA_RBS_HEADERS_B D
WHERE NVL(D.CBS_ENABLED
, 'N') = 'N'
AND D.RBS_HEADER_ID = H.RBS_HEADER_ID