MNT_OPERATING_ORGS_V

Details

• Schema: FUSION

• Object owner: MNT

• Object type: VIEW

Columns

Name
OPERATING_ORG_ID OPERATING_ORG_CODE OPERATING_ORG_NAME MAINTENANCE_ORG_ID

Query

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