VIEW: APPS.AK_FOREIGN_KEY_MAPPING_V

Source

View Text - Preformatted

SELECT DISTINCT afk.foreign_key_name, afkc.foreign_key_sequence key_sequence, afkc.attribute_application_id foreign_application_id, afkc.attribute_code foreign_attribute_code, aoaf.column_name foreign_column_name, afk.unique_key_name, auk.database_object_name, aukc.attribute_application_id unique_application_id, aukc.attribute_code unique_attribute_code, aoau.column_name unique_column_name FROM ak_unique_key_columns aukc, ak_unique_keys auk, ak_object_attributes aoau, ak_foreign_key_columns afkc, ak_foreign_keys afk, ak_object_attributes aoaf WHERE aoaf.attribute_application_id = afkc.attribute_application_id AND aoaf.attribute_code = afkc.attribute_code AND aoaf.database_object_name = afk.database_object_name AND aoau.attribute_application_id = aukc.attribute_application_id AND aoau.attribute_code = aukc.attribute_code AND aoau.database_object_name = auk.database_object_name AND aukc.unique_key_sequence = afkc.foreign_key_sequence AND aukc.unique_key_name = afk.unique_key_name AND auk.unique_key_name = afk.unique_key_name AND afkc.foreign_key_name = afk.foreign_key_name

View Text - HTML Formatted

SELECT DISTINCT AFK.FOREIGN_KEY_NAME
, AFKC.FOREIGN_KEY_SEQUENCE KEY_SEQUENCE
, AFKC.ATTRIBUTE_APPLICATION_ID FOREIGN_APPLICATION_ID
, AFKC.ATTRIBUTE_CODE FOREIGN_ATTRIBUTE_CODE
, AOAF.COLUMN_NAME FOREIGN_COLUMN_NAME
, AFK.UNIQUE_KEY_NAME
, AUK.DATABASE_OBJECT_NAME
, AUKC.ATTRIBUTE_APPLICATION_ID UNIQUE_APPLICATION_ID
, AUKC.ATTRIBUTE_CODE UNIQUE_ATTRIBUTE_CODE
, AOAU.COLUMN_NAME UNIQUE_COLUMN_NAME
FROM AK_UNIQUE_KEY_COLUMNS AUKC
, AK_UNIQUE_KEYS AUK
, AK_OBJECT_ATTRIBUTES AOAU
, AK_FOREIGN_KEY_COLUMNS AFKC
, AK_FOREIGN_KEYS AFK
, AK_OBJECT_ATTRIBUTES AOAF
WHERE AOAF.ATTRIBUTE_APPLICATION_ID = AFKC.ATTRIBUTE_APPLICATION_ID
AND AOAF.ATTRIBUTE_CODE = AFKC.ATTRIBUTE_CODE
AND AOAF.DATABASE_OBJECT_NAME = AFK.DATABASE_OBJECT_NAME
AND AOAU.ATTRIBUTE_APPLICATION_ID = AUKC.ATTRIBUTE_APPLICATION_ID
AND AOAU.ATTRIBUTE_CODE = AUKC.ATTRIBUTE_CODE
AND AOAU.DATABASE_OBJECT_NAME = AUK.DATABASE_OBJECT_NAME
AND AUKC.UNIQUE_KEY_SEQUENCE = AFKC.FOREIGN_KEY_SEQUENCE
AND AUKC.UNIQUE_KEY_NAME = AFK.UNIQUE_KEY_NAME
AND AUK.UNIQUE_KEY_NAME = AFK.UNIQUE_KEY_NAME
AND AFKC.FOREIGN_KEY_NAME = AFK.FOREIGN_KEY_NAME