VIEW: APPS.OE_PC_FKEY_COLS_V

Source

View Text - Preformatted

SELECT fk.application_id ,fk.database_object_name db_object_name ,'VIEW' db_object_type ,fk.foreign_key_name ,fkc.foreign_key_sequence fk_column_sequence ,fakoa.column_name fk_column_name ,fk.unique_key_name unique_key_name ,uk.application_id uk_application_id ,uk.database_object_name uk_db_object_name ,uakoa.column_name uk_column_name from ak_foreign_keys fk, ak_foreign_key_columns fkc, ak_object_attributes fakoa, ak_unique_keys uk, ak_unique_key_columns ukc, ak_object_attributes uakoa WHERE fk.foreign_key_name = fkc.foreign_key_name and fkc.attribute_application_id = fakoa.attribute_application_id and fkc.attribute_code = fakoa.attribute_code and fk.database_object_name = fakoa.database_object_name and fk.unique_key_name = uk.unique_key_name and uk.unique_key_name = ukc.unique_key_name and fkc.foreign_key_sequence = ukc.unique_key_sequence and ukc.attribute_application_id = uakoa.attribute_application_id and ukc.attribute_code = uakoa.attribute_code and uk.database_object_name = uakoa.database_object_name

View Text - HTML Formatted

SELECT FK.APPLICATION_ID
, FK.DATABASE_OBJECT_NAME DB_OBJECT_NAME
, 'VIEW' DB_OBJECT_TYPE
, FK.FOREIGN_KEY_NAME
, FKC.FOREIGN_KEY_SEQUENCE FK_COLUMN_SEQUENCE
, FAKOA.COLUMN_NAME FK_COLUMN_NAME
, FK.UNIQUE_KEY_NAME UNIQUE_KEY_NAME
, UK.APPLICATION_ID UK_APPLICATION_ID
, UK.DATABASE_OBJECT_NAME UK_DB_OBJECT_NAME
, UAKOA.COLUMN_NAME UK_COLUMN_NAME
FROM AK_FOREIGN_KEYS FK
, AK_FOREIGN_KEY_COLUMNS FKC
, AK_OBJECT_ATTRIBUTES FAKOA
, AK_UNIQUE_KEYS UK
, AK_UNIQUE_KEY_COLUMNS UKC
, AK_OBJECT_ATTRIBUTES UAKOA
WHERE FK.FOREIGN_KEY_NAME = FKC.FOREIGN_KEY_NAME
AND FKC.ATTRIBUTE_APPLICATION_ID = FAKOA.ATTRIBUTE_APPLICATION_ID
AND FKC.ATTRIBUTE_CODE = FAKOA.ATTRIBUTE_CODE
AND FK.DATABASE_OBJECT_NAME = FAKOA.DATABASE_OBJECT_NAME
AND FK.UNIQUE_KEY_NAME = UK.UNIQUE_KEY_NAME
AND UK.UNIQUE_KEY_NAME = UKC.UNIQUE_KEY_NAME
AND FKC.FOREIGN_KEY_SEQUENCE = UKC.UNIQUE_KEY_SEQUENCE
AND UKC.ATTRIBUTE_APPLICATION_ID = UAKOA.ATTRIBUTE_APPLICATION_ID
AND UKC.ATTRIBUTE_CODE = UAKOA.ATTRIBUTE_CODE
AND UK.DATABASE_OBJECT_NAME = UAKOA.DATABASE_OBJECT_NAME