VIEW: APPS.OKE_FLDMX_PFORMTYPE_RTREE_V

Source

View Text - Preformatted

SELECT 'BIZAREA' CTX, -1 INIT_STAT, 1 DEPTH, BUSINESS_AREA_NAME LABEL, BUSINESS_AREA_CODE DATA, BUSINESS_AREA_NAME SORT_KEY FROM OKE_BUSINESS_AREAS_V UNION SELECT F.FLOWDOWN_TYPE, 0 , 2 , T.PRINT_FORM_TYPE_NAME , RPAD(F.BUSINESS_AREA_CODE , 30 , ' ') || F.FLOWDOWN_CODE , RPAD(BA.BUSINESS_AREA_NAME , 80 , ' ') || T.PRINT_FORM_TYPE_NAME FROM OKE_FLOWDOWNS F , OKE_PRINT_FORM_TYPES_V T , OKE_BUSINESS_AREAS_V BA WHERE F.FLOWDOWN_TYPE='PRINT_FORM_TYPE' AND T.PRINT_FORM_TYPE_CODE = F.FLOWDOWN_CODE AND BA.BUSINESS_AREA_CODE = F.BUSINESS_AREA_CODE

View Text - HTML Formatted

SELECT 'BIZAREA' CTX
, -1 INIT_STAT
, 1 DEPTH
, BUSINESS_AREA_NAME LABEL
, BUSINESS_AREA_CODE DATA
, BUSINESS_AREA_NAME SORT_KEY
FROM OKE_BUSINESS_AREAS_V UNION SELECT F.FLOWDOWN_TYPE
, 0
, 2
, T.PRINT_FORM_TYPE_NAME
, RPAD(F.BUSINESS_AREA_CODE
, 30
, ' ') || F.FLOWDOWN_CODE
, RPAD(BA.BUSINESS_AREA_NAME
, 80
, ' ') || T.PRINT_FORM_TYPE_NAME
FROM OKE_FLOWDOWNS F
, OKE_PRINT_FORM_TYPES_V T
, OKE_BUSINESS_AREAS_V BA
WHERE F.FLOWDOWN_TYPE='PRINT_FORM_TYPE'
AND T.PRINT_FORM_TYPE_CODE = F.FLOWDOWN_CODE
AND BA.BUSINESS_AREA_CODE = F.BUSINESS_AREA_CODE