VIEW: APPS.AK_UNIQUE_KEY_COLUMNS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')