DOO_PC_VENTITIES_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name
MODULE_ID ENTITY_ID ENTITY_CODE ENTITY_DESCRIPTION DB_OBJECT_NAME VALIDATION_MODULE_ID VALIDATION_ENTITY_ID VALIDATION_ENTITY_CODE VALIDATION_ENTITY_DESCRIPTION VALIDATION_DB_OBJECT_NAME

Query

SQL_Statement

select module_id module_id ,entity_id entity_id ,entity_code entity_code ,description entity_description ,database_object_name db_object_name ,module_id validation_module_id ,entity_id validation_entity_id ,entity_code validation_entity_code ,description validation_entity_description ,database_object_name validation_db_object_name from doo_pc_entities_v union select module_id ,entity_id ,entity_code ,description ,database_object_name ,module_id ,related_entity_id ,related_entity_code ,description ,related_db_object_name from doo_pc_rentities_v union select module_id ,related_entity_id ,related_entity_code ,description ,related_db_object_name ,module_id ,entity_id ,entity_code ,description ,database_object_name from doo_pc_rentities_v