eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AK_FOREIGN_KEYS_VL

Source

View Text - Preformatted


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

View Text - HTML Formatted

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