[Home] [Help]
View: OE_DEF_AK_FKEY_COLS_V
View Text
SELECT A.ATTRIBUTE_CODE
, B.COLUMN_NAME
, B.DATABASE_OBJECT_NAME
, A.FOREIGN_KEY_NAME
, A.FOREIGN_KEY_SEQUENCE
, A.ATTRIBUTE_APPLICATION_ID
FROM AK_OBJECT_ATTRIBUTES B
, AK_FOREIGN_KEY_COLUMNS A
WHERE B.ATTRIBUTE_CODE = A.ATTRIBUTE_CODE
AND B.ATTRIBUTE_APPLICATION_ID = A.ATTRIBUTE_APPLICATION_ID
Columns
Name |
ATTRIBUTE_CODE |
COLUMN_NAME |
DATABASE_OBJECT_NAME |
FOREIGN_KEY_NAME |
FOREIGN_KEY_SEQUENCE |
ATTRIBUTE_APPLICATION_ID |