VIEW: APPS.OKE_OBJECT_ATTRIBUTES_VL

Source

View Text - Preformatted

SELECT B.ROWID , B.DATABASE_OBJECT_NAME , B.ATTRIBUTE_CODE , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , T.ATTRIBUTE_NAME , T.DESCRIPTION , B.DATATYPE , B.SECURABLE_FLAG , B.QUERYABLE_FLAG , B.VIEW_COLUMN_FLAG , B.FORM_ITEM_FLAG , B.ATTRIBUTE_GROUP_CODE , B.PARENT_ATTRIBUTE_CODE FROM OKE_OBJECT_ATTRIBUTES_B B , OKE_OBJECT_ATTRIBUTES_TL T WHERE T.DATABASE_OBJECT_NAME = B.DATABASE_OBJECT_NAME AND T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE AND T.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID
, B.DATABASE_OBJECT_NAME
, B.ATTRIBUTE_CODE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.ATTRIBUTE_NAME
, T.DESCRIPTION
, B.DATATYPE
, B.SECURABLE_FLAG
, B.QUERYABLE_FLAG
, B.VIEW_COLUMN_FLAG
, B.FORM_ITEM_FLAG
, B.ATTRIBUTE_GROUP_CODE
, B.PARENT_ATTRIBUTE_CODE
FROM OKE_OBJECT_ATTRIBUTES_B B
, OKE_OBJECT_ATTRIBUTES_TL T
WHERE T.DATABASE_OBJECT_NAME = B.DATABASE_OBJECT_NAME
AND T.ATTRIBUTE_CODE = B.ATTRIBUTE_CODE
AND T.LANGUAGE = USERENV('LANG')