Product: | AK - Common Modules-AK |
---|---|
Description: | 10sc only |
Implementation/DBA Data: | APPS.AK_UNIQUE_KEY_COLUMNS_V |
SELECT AUKC.ROWID ROW_ID
, AUKC.UNIQUE_KEY_NAME
, AUKC.UNIQUE_KEY_SEQUENCE
, AUKC.ATTRIBUTE_CODE
, AUKC.ATTRIBUTE_APPLICATION_ID
, FAV.APPLICATION_NAME
, AAT.NAME ATTRIBUTE_NAME
, AUKC.ATTRIBUTE_CATEGORY
, AUKC.ATTRIBUTE1
, AUKC.ATTRIBUTE2
, AUKC.ATTRIBUTE3
, AUKC.ATTRIBUTE4
, AUKC.ATTRIBUTE5
, AUKC.ATTRIBUTE6
, AUKC.ATTRIBUTE7
, AUKC.ATTRIBUTE8
, AUKC.ATTRIBUTE9
, AUKC.ATTRIBUTE10
, AUKC.ATTRIBUTE11
, AUKC.ATTRIBUTE12
, AUKC.ATTRIBUTE13
, AUKC.ATTRIBUTE14
, AUKC.ATTRIBUTE15
, AUKC.LAST_UPDATE_DATE
, AUKC.LAST_UPDATED_BY
, AUKC.CREATION_DATE
, AUKC.CREATED_BY
, AUKC.LAST_UPDATE_LOGIN
FROM AK_UNIQUE_KEY_COLUMNS AUKC
, AK_ATTRIBUTES_TL AAT
, FND_APPLICATION_VL FAV
WHERE FAV.APPLICATION_ID = AUKC.ATTRIBUTE_APPLICATION_ID
AND AAT.ATTRIBUTE_APPLICATION_ID = AUKC.ATTRIBUTE_APPLICATION_ID
AND AAT.ATTRIBUTE_CODE = AUKC.ATTRIBUTE_CODE
AND AAT.LANGUAGE = USERENV('LANG')