DOO_PC_FKEY_COLS_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name
MODULE_ID DB_OBJECT_NAME DB_OBJECT_TYPE FOREIGN_KEY_NAME FK_COLUMN_NAME UNIQUE_KEY_NAME UK_APPLICATION_ID UK_DB_OBJECT_NAME UK_COLUMN_NAME

Query

SQL_Statement

SELECT distinct fk.module_id , fk.database_object_name db_object_name ,'VIEW' db_object_type ,fk.foreign_key_name ,fdoooa.column_name fk_column_name ,fk.unique_key_name unique_key_name ,uk.module_id uk_application_id ,uk.database_object_name uk_db_object_name ,udoooa.column_name uk_column_name from doo_foreign_keys fk, doo_foreign_key_columns fkc, doo_object_attributes_vl fdoooa, doo_unique_keys uk, doo_unique_key_columns ukc, doo_object_attributes_vl udoooa WHERE fk.foreign_key_name = fkc.foreign_key_name and fkc.attribute_code = fdoooa.attribute_code and fk.database_object_name = fdoooa.database_object_name and fk.unique_key_name = uk.unique_key_name and uk.unique_key_name = ukc.unique_key_name and ukc.attribute_code = udoooa.attribute_code and uk.database_object_name = udoooa.database_object_name