VIEW: APPS.OKE_ATTRGRP_AVAIL_V

Source

View Text - Preformatted

SELECT OA.DATABASE_OBJECT_NAME , 0 , 1 , OA.ATTRIBUTE_NAME , 'okeattr' , OA.ATTRIBUTE_CODE , OA.ATTRIBUTE_NAME FROM OKE_OBJECT_ATTRIBUTES_VL OA , OKE_ATTRIBUTE_GROUPS_V AG WHERE AG.ATTRIBUTE_GROUP_CODE (+) = OA.ATTRIBUTE_GROUP_CODE AND AG.ATTRIBUTE_GROUP_CODE IS NULL AND OA.PARENT_ATTRIBUTE_CODE IS NULL AND OA.QUERYABLE_FLAG = 'Y'

View Text - HTML Formatted

SELECT OA.DATABASE_OBJECT_NAME
, 0
, 1
, OA.ATTRIBUTE_NAME
, 'OKEATTR'
, OA.ATTRIBUTE_CODE
, OA.ATTRIBUTE_NAME
FROM OKE_OBJECT_ATTRIBUTES_VL OA
, OKE_ATTRIBUTE_GROUPS_V AG
WHERE AG.ATTRIBUTE_GROUP_CODE (+) = OA.ATTRIBUTE_GROUP_CODE
AND AG.ATTRIBUTE_GROUP_CODE IS NULL
AND OA.PARENT_ATTRIBUTE_CODE IS NULL
AND OA.QUERYABLE_FLAG = 'Y'