MNT_SECURED_OPERATING_ORGS_V

Details

• Schema: FUSION

• Object owner: MNT

• Object type: VIEW

Columns

Name
OPERATING_ORG_ID OPERATING_ORG_CODE OPERATING_ORG_NAME

Query

SQL_Statement

SELECT mao.organization_id operating_org_id, mao.organization_code operating_org_code, mao.organization_name operating_org_name FROM mnt_accessible_organizations_v mao UNION SELECT cor.related_organization_Id operating_org_id, relatedOrg.organization_code operating_org_code, relatedOrg.organization_name operating_org_name FROM cse_org_relationships cor, rcs_org_definitions_lw_v relatedOrg WHERE cor.related_organization_id = relatedOrg.organization_id and cor.organization_id in (select mao1.organization_id from mnt_accessible_organizations_v mao1)