VIEW: APPS.OKE_FLDMX_ATTRGRP_RTREE_V

Source

View Text - Preformatted

SELECT 'BIZAREA' , -1 , 1 , BUSINESS_AREA_NAME , BUSINESS_AREA_CODE , BUSINESS_AREA_NAME FROM OKE_BUSINESS_AREAS_V UNION SELECT 'ATTRGRP' , 0 , 2 , ATS.ATTRIBUTE_GROUP_NAME , RPAD(AF.BUSINESS_AREA_CODE , 30 , ' ') || RPAD(AF.FLOWDOWN_CODE , 30 , ' ') || AF.ATTRIBUTE_GROUP_TYPE , RPAD(BA.BUSINESS_AREA_NAME , 80 , ' ') || ATS.ATTRIBUTE_GROUP_NAME FROM OKE_FLOWDOWNS AF, OKE_ATTRIBUTE_GROUPS_V ATS , OKE_BUSINESS_AREAS_V BA WHERE AF.FLOWDOWN_TYPE='ATTRIBUTE' AND ATS.ATTRIBUTE_GROUP_TYPE='SYSTEM' AND ATS.ATTRIBUTE_GROUP_CODE = AF.FLOWDOWN_CODE AND BA.BUSINESS_AREA_CODE = AF.BUSINESS_AREA_CODE

View Text - HTML Formatted

SELECT 'BIZAREA'
, -1
, 1
, BUSINESS_AREA_NAME
, BUSINESS_AREA_CODE
, BUSINESS_AREA_NAME
FROM OKE_BUSINESS_AREAS_V UNION SELECT 'ATTRGRP'
, 0
, 2
, ATS.ATTRIBUTE_GROUP_NAME
, RPAD(AF.BUSINESS_AREA_CODE
, 30
, ' ') || RPAD(AF.FLOWDOWN_CODE
, 30
, ' ') || AF.ATTRIBUTE_GROUP_TYPE
, RPAD(BA.BUSINESS_AREA_NAME
, 80
, ' ') || ATS.ATTRIBUTE_GROUP_NAME
FROM OKE_FLOWDOWNS AF
, OKE_ATTRIBUTE_GROUPS_V ATS
, OKE_BUSINESS_AREAS_V BA
WHERE AF.FLOWDOWN_TYPE='ATTRIBUTE'
AND ATS.ATTRIBUTE_GROUP_TYPE='SYSTEM'
AND ATS.ATTRIBUTE_GROUP_CODE = AF.FLOWDOWN_CODE
AND BA.BUSINESS_AREA_CODE = AF.BUSINESS_AREA_CODE