View: AK_FOREIGN_KEY_COLUMNS_V

Product:	AK - Common Modules-AK
Description:	10SC ONLY
Implementation/DBA Data:	APPS.AK_FOREIGN_KEY_COLUMNS_V

View Text

SELECT AFKC.ROWID ROW_ID
, AFKC.FOREIGN_KEY_NAME
, AFKC.ATTRIBUTE_CODE
, AFKC.ATTRIBUTE_APPLICATION_ID
, FAV.APPLICATION_NAME
, AUKC.ATTRIBUTE_CODE PRIMARY_KEY_COLUMN_NAME
, AFKC.FOREIGN_KEY_SEQUENCE
, AFKC.ATTRIBUTE_CATEGORY
, AFKC.ATTRIBUTE1
, AFKC.ATTRIBUTE2
, AFKC.ATTRIBUTE3
, AFKC.ATTRIBUTE4
, AFKC.ATTRIBUTE5
, AFKC.ATTRIBUTE6
, AFKC.ATTRIBUTE7
, AFKC.ATTRIBUTE8
, AFKC.ATTRIBUTE9
, AFKC.ATTRIBUTE10
, AFKC.ATTRIBUTE11
, AFKC.ATTRIBUTE12
, AFKC.ATTRIBUTE13
, AFKC.ATTRIBUTE14
, AFKC.ATTRIBUTE15
, AFKC.LAST_UPDATE_DATE
, AFKC.LAST_UPDATED_BY
, AFKC.CREATION_DATE
, AFKC.CREATED_BY
, AFKC.LAST_UPDATE_LOGIN
FROM AK_FOREIGN_KEY_COLUMNS AFKC
, AK_FOREIGN_KEYS AFK
, FND_APPLICATION_VL FAV
, AK_UNIQUE_KEY_COLUMNS AUKC
WHERE AUKC.UNIQUE_KEY_SEQUENCE = AFKC.FOREIGN_KEY_SEQUENCE
AND AUKC.UNIQUE_KEY_NAME = AFK.UNIQUE_KEY_NAME
AND AFK.FOREIGN_KEY_NAME = AFKC.FOREIGN_KEY_NAME
AND FAV.APPLICATION_ID = AFKC.ATTRIBUTE_APPLICATION_ID

Columns