1. Tables and Views for Project Management
  2. GMS_GDA_ONLY_ORG_V

GMS_GDA_ONLY_ORG_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

Query

SQL_Statement

select distinct ORGD.CHILD_ORGANIZATION_ID as ORGANIZATION_ID

from FUN_USER_ROLE_DATA_ASGNMNTS FURD,

PJF_ORG_HIERARCHY_DENORM ORGD,

FND_SESSION_ROLE_SETS SROLE

where FURD.USER_GUID = FND_GLOBAL.USER_GUID

and FURD.ROLE_NAME = SROLE.ROLE_NAME

and SROLE.SESSION_ROLE_SET_KEY = FND_GLOBAL.SESSION_ROLE_SET_KEY

and NVL(FURD.ACTIVE_FLAG,'N') != 'N'

and FURD.DATASEC_CONTEXT_TYPE_CODE = 'ORA_PRJ_AWARD_ORG_HIER_ID'

and FURD.DATASEC_CONTEXT_VALUE1 = ORGD.TREE_STRUCTURE_CODE

and FURD.DATASEC_CONTEXT_VALUE2 = ORGD.TREE_VERSION_ID

and FURD.DATASEC_CONTEXT_VALUE3 = ORGD.PARENT_ORGANIZATION_ID

and FURD.DATASEC_CONTEXT_VALUE4 = ORGD.TREE_CODE

and FURD.DATASEC_CONTEXT_VALUE3 is not null