MNT_OPERATING_ORGS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MNT
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
OPERATING_ORG_ID OPERATING_ORG_CODE OPERATING_ORG_NAME MAINTENANCE_ORG_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT rmp.organization_id operating_org_id, rmp.organization_code operating_org_code, rmp.organization_name operating_org_name, rmp.organization_id maintenance_org_id FROM rcs_mnt_parameters_v rmp UNION SELECT cor.related_organization_Id operating_org_id, relatedOrg.organization_code operating_org_code, relatedOrg.organization_name operating_org_name, cor.Organization_Id maintenance_org_id FROM cse_org_relationships cor, rcs_org_definitions_lw_v relatedOrg WHERE cor.related_organization_id = relatedOrg.organization_id |