VIEW: APPS.OE_DEF_AK_FKEY_COLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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