DBA Data[Home] [Help]

VIEW: APPS.AK_UNIQUE_KEYS_V

Source

View Text - Preformatted

SELECT AUK.ROWID ROW_ID , AUK.UNIQUE_KEY_NAME , AOT.NAME , AOT.DESCRIPTION , AUK.DATABASE_OBJECT_NAME , AUK.APPLICATION_ID , AUK.ATTRIBUTE_CATEGORY , AUK.ATTRIBUTE1 , AUK.ATTRIBUTE2 , AUK.ATTRIBUTE3 , AUK.ATTRIBUTE4 , AUK.ATTRIBUTE5 , AUK.ATTRIBUTE6 , AUK.ATTRIBUTE7 , AUK.ATTRIBUTE8 , AUK.ATTRIBUTE9 , AUK.ATTRIBUTE10 , AUK.ATTRIBUTE11 , AUK.ATTRIBUTE12 , AUK.ATTRIBUTE13 , AUK.ATTRIBUTE14 , AUK.ATTRIBUTE15 , AUK.LAST_UPDATE_DATE , AUK.LAST_UPDATED_BY , AUK.CREATION_DATE , AUK.CREATED_BY , AUK.LAST_UPDATE_LOGIN FROM AK_OBJECTS_TL AOT, AK_UNIQUE_KEYS AUK WHERE AOT.DATABASE_OBJECT_NAME = AUK.DATABASE_OBJECT_NAME AND AOT.LANGUAGE = USERENV('LANG')
View Text - HTML Formatted

SELECT AUK.ROWID ROW_ID
, AUK.UNIQUE_KEY_NAME
, AOT.NAME
, AOT.DESCRIPTION
, AUK.DATABASE_OBJECT_NAME
, AUK.APPLICATION_ID
, AUK.ATTRIBUTE_CATEGORY
, AUK.ATTRIBUTE1
, AUK.ATTRIBUTE2
, AUK.ATTRIBUTE3
, AUK.ATTRIBUTE4
, AUK.ATTRIBUTE5
, AUK.ATTRIBUTE6
, AUK.ATTRIBUTE7
, AUK.ATTRIBUTE8
, AUK.ATTRIBUTE9
, AUK.ATTRIBUTE10
, AUK.ATTRIBUTE11
, AUK.ATTRIBUTE12
, AUK.ATTRIBUTE13
, AUK.ATTRIBUTE14
, AUK.ATTRIBUTE15
, AUK.LAST_UPDATE_DATE
, AUK.LAST_UPDATED_BY
, AUK.CREATION_DATE
, AUK.CREATED_BY
, AUK.LAST_UPDATE_LOGIN
FROM AK_OBJECTS_TL AOT
, AK_UNIQUE_KEYS AUK
WHERE AOT.DATABASE_OBJECT_NAME = AUK.DATABASE_OBJECT_NAME
AND AOT.LANGUAGE = USERENV('LANG')