VIEW: APPS.OKE_FLDMX_STDNOTE_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 'STDNOTE' , 0 , 2 , SNT.STD_NOTE_NAME , RPAD(SNF.BUSINESS_AREA_CODE , 30 , ' ') || SNF.FLOWDOWN_CODE , RPAD(BA.BUSINESS_AREA_NAME , 80 , ' ') || SNT.STD_NOTE_NAME FROM OKE_FLOWDOWNS SNF , OKE_STD_NOTES_V SNT , OKE_BUSINESS_AREAS_V BA WHERE SNF.FLOWDOWN_TYPE='STD_NOTE' AND SNT.STD_NOTE_CODE = SNF.FLOWDOWN_CODE AND BA.BUSINESS_AREA_CODE = SNF.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 'STDNOTE'
, 0
, 2
, SNT.STD_NOTE_NAME
, RPAD(SNF.BUSINESS_AREA_CODE
, 30
, ' ') || SNF.FLOWDOWN_CODE
, RPAD(BA.BUSINESS_AREA_NAME
, 80
, ' ') || SNT.STD_NOTE_NAME
FROM OKE_FLOWDOWNS SNF
, OKE_STD_NOTES_V SNT
, OKE_BUSINESS_AREAS_V BA
WHERE SNF.FLOWDOWN_TYPE='STD_NOTE'
AND SNT.STD_NOTE_CODE = SNF.FLOWDOWN_CODE
AND BA.BUSINESS_AREA_CODE = SNF.BUSINESS_AREA_CODE