View: OKE_FLDMX_DOCUMENT_RTREE_V

Product:	OKE - Project Contracts
Description:	View returning attachment categories have been assigned to business area in flowdown matrix
Implementation/DBA Data:	APPS.OKE_FLDMX_DOCUMENT_RTREE_V

View Text

SELECT 'BIZAREA'
, -1
, 1
, BUSINESS_AREA_NAME
, BUSINESS_AREA_CODE
, BUSINESS_AREA_NAME
FROM OKE_BUSINESS_AREAS_V UNION SELECT 'DOCUMENT'
, 0
, 2
, DC.USER_NAME
, RPAD(DF.BUSINESS_AREA_CODE
, 30
, ' ') || DF.DOCUMENT_CATEGORY_ID
, RPAD(BA.BUSINESS_AREA_NAME
, 80
, ' ') || DC.USER_NAME
FROM OKE_DOCUMENT_FLOWDOWNS DF
, FND_DOCUMENT_CATEGORIES_VL DC
, OKE_BUSINESS_AREAS_V BA
WHERE DC.CATEGORY_ID = DF.DOCUMENT_CATEGORY_ID
AND BA.BUSINESS_AREA_CODE = DF.BUSINESS_AREA_CODE

Columns