[Home] [Help]
View: OKE_FLDMX_ATTRGRP_RTREE_V
Product: | OKE - Project Contracts |
Description: | View returning attribute groups have been assigned to business area in flowdown matrix |
Implementation/DBA Data: |
APPS.OKE_FLDMX_ATTRGRP_RTREE_V
|
View Text
SELECT 'BIZAREA'
, -1
, 1
, BUSINESS_AREA_NAME
, BUSINESS_AREA_CODE
, BUSINESS_AREA_NAME
FROM OKE_BUSINESS_AREAS_V UNION SELECT 'ATTRGRP'
, 0
, 2
, AG.ATTRIBUTE_GROUP_NAME
, RPAD(AF.BUSINESS_AREA_CODE
, 30
, ' ') || RPAD(AF.ATTRIBUTE_GROUP_TYPE
, 10
, ' ') || AF.ATTRIBUTE_GROUP_CODE
, RPAD(BA.BUSINESS_AREA_NAME
, 80
, ' ') || RPAD(AF.ATTRIBUTE_GROUP_TYPE
, 10
, ' ') || AG.ATTRIBUTE_GROUP_NAME
FROM OKE_ATTRIBUTE_FLOWDOWNS AF
, OKE_ATTRIBUTE_GROUPS_V AG
, OKE_BUSINESS_AREAS_V BA
WHERE AG.ATTRIBUTE_GROUP_TYPE = AF.ATTRIBUTE_GROUP_TYPE
AND AG.ATTRIBUTE_GROUP_CODE = AF.ATTRIBUTE_GROUP_CODE
AND BA.BUSINESS_AREA_CODE = AF.BUSINESS_AREA_CODE
Columns
Name |
CTX |
INIT_STAT |
DEPTH |
LABEL |
DATA |
SORT_KEY |