DOO_PC_RENTITIES_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name
MODULE_ID ENTITY_ID ENTITY_CODE DESCRIPTION DATABASE_OBJECT_NAME RELATED_ENTITY_ID RELATED_ENTITY_CODE RELATED_DB_OBJECT_NAME

Query

SQL_Statement

SELECT e.module_id , e.entity_id ,e.entity_code, e.description , e.database_object_name, re.entity_id related_entity_id,re.entity_code related_entity_code, re.database_object_name related_db_object_name FROM doo_pc_entities_v e, doo_pc_entities_v re, doo_pc_fkeys_v efk WHERE e.module_id = efk.module_id AND e.database_object_name = efk.db_object_name AND e.database_object_type = efk.db_object_type AND efk.uk_module_id = re.module_id and efk.uk_db_object_name = re.database_object_name