Product: | OKE - Project Contracts |
---|---|
Description: | Object attributes multi-lingual view |
Implementation/DBA Data: | APPS.OKE_OBJECT_ATTRIBUTES_VL |
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')