VIEW: APPS.OKE_ATTRGRP_ASSIGNED_V

Source

View Text - Preformatted

SELECT NULL , -1 , 1 , AG.ATTRIBUTE_GROUP_NAME , 'okeatgrp' , AG.ATTRIBUTE_GROUP_CODE , AG.ATTRIBUTE_GROUP_NAME FROM OKE_ATTRIBUTE_GROUPS_V AG WHERE ATTRIBUTE_GROUP_TYPE = 'SYSTEM' UNION ALL SELECT OA.DATABASE_OBJECT_NAME , 0 , 2 , OA.ATTRIBUTE_NAME , 'okeattr' , RPAD(OA.ATTRIBUTE_GROUP_CODE , 30 , ' ') || OA.ATTRIBUTE_CODE , RPAD(AG.ATTRIBUTE_GROUP_NAME , 80 , ' ') || OA.ATTRIBUTE_NAME FROM OKE_OBJECT_ATTRIBUTES_VL OA , OKE_ATTRIBUTE_GROUPS_V AG WHERE OA.ATTRIBUTE_GROUP_CODE = AG.ATTRIBUTE_GROUP_CODE AND OA.PARENT_ATTRIBUTE_CODE IS NULL AND OA.QUERYABLE_FLAG = 'Y'

View Text - HTML Formatted

SELECT NULL
, -1
, 1
, AG.ATTRIBUTE_GROUP_NAME
, 'OKEATGRP'
, AG.ATTRIBUTE_GROUP_CODE
, AG.ATTRIBUTE_GROUP_NAME
FROM OKE_ATTRIBUTE_GROUPS_V AG
WHERE ATTRIBUTE_GROUP_TYPE = 'SYSTEM' UNION ALL SELECT OA.DATABASE_OBJECT_NAME
, 0
, 2
, OA.ATTRIBUTE_NAME
, 'OKEATTR'
, RPAD(OA.ATTRIBUTE_GROUP_CODE
, 30
, ' ') || OA.ATTRIBUTE_CODE
, RPAD(AG.ATTRIBUTE_GROUP_NAME
, 80
, ' ') || OA.ATTRIBUTE_NAME
FROM OKE_OBJECT_ATTRIBUTES_VL OA
, OKE_ATTRIBUTE_GROUPS_V AG
WHERE OA.ATTRIBUTE_GROUP_CODE = AG.ATTRIBUTE_GROUP_CODE
AND OA.PARENT_ATTRIBUTE_CODE IS NULL
AND OA.QUERYABLE_FLAG = 'Y'