Product: | AK - Common Modules-AK |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.AK_FOREIGN_KEY_MAPPING_V |
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