DOO_PC_RENTITIES_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: DOO
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
MODULE_ID ENTITY_ID ENTITY_CODE DESCRIPTION DATABASE_OBJECT_NAME RELATED_ENTITY_ID RELATED_ENTITY_CODE RELATED_DB_OBJECT_NAME |
問合せ
| 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 |