View: AK_FOREIGN_KEYS_VL

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

View Text

SELECT AFK.ROWID ROW_ID
, AFK.FOREIGN_KEY_NAME
, AFK.DATABASE_OBJECT_NAME
, AFKT.FROM_TO_NAME
, AFKT.FROM_TO_DESCRIPTION
, AFKT.TO_FROM_NAME
, AFKT.TO_FROM_DESCRIPTION
, AOT1.NAME TO_OBJECT_NAME
, AOT1.DESCRIPTION TO_OBJECT_DESCRIPTION
, AO1.DATABASE_OBJECT_NAME TO_DATABASE_OBJECT_NAME
, AOT2.NAME FROM_OBJECT_NAME
, AOT2.DESCRIPTION FROM_OBJECT_DESCRIPTION
, AO2.DATABASE_OBJECT_NAME FROM_DATABASE_OBJECT_NAME
, AFK.UNIQUE_KEY_NAME
, AFK.APPLICATION_ID
, AFK.ATTRIBUTE_CATEGORY
, AFK.ATTRIBUTE1
, AFK.ATTRIBUTE2
, AFK.ATTRIBUTE3
, AFK.ATTRIBUTE4
, AFK.ATTRIBUTE5
, AFK.ATTRIBUTE6
, AFK.ATTRIBUTE7
, AFK.ATTRIBUTE8
, AFK.ATTRIBUTE9
, AFK.ATTRIBUTE10
, AFK.ATTRIBUTE11
, AFK.ATTRIBUTE12
, AFK.ATTRIBUTE13
, AFK.ATTRIBUTE14
, AFK.ATTRIBUTE15
, AFK.LAST_UPDATE_DATE
, AFK.LAST_UPDATED_BY
, AFK.CREATION_DATE
, AFK.CREATED_BY
, AFK.LAST_UPDATE_LOGIN
FROM AK_OBJECTS AO1
, AK_OBJECTS AO2
, AK_OBJECTS_TL AOT1
, AK_OBJECTS_TL AOT2
, AK_UNIQUE_KEYS AUK
, AK_FOREIGN_KEYS AFK
, AK_FOREIGN_KEYS_TL AFKT
WHERE AO1.DATABASE_OBJECT_NAME(+) = AFK.DATABASE_OBJECT_NAME
AND AOT1.LANGUAGE(+) = USERENV('LANG')
AND AOT1.DATABASE_OBJECT_NAME(+) = AFK.DATABASE_OBJECT_NAME
AND AO2.DATABASE_OBJECT_NAME(+) = AUK.DATABASE_OBJECT_NAME
AND AOT2.LANGUAGE(+) = USERENV('LANG')
AND AOT2.DATABASE_OBJECT_NAME(+) = AUK.DATABASE_OBJECT_NAME
AND AUK.UNIQUE_KEY_NAME = AFK.UNIQUE_KEY_NAME
AND AFK.FOREIGN_KEY_NAME = AFKT.FOREIGN_KEY_NAME
AND AFKT.LANGUAGE = USERENV('LANG')

Columns