1. Tables and Views for Project Management
  2. GMS_GDA_ORG_LIST_V

GMS_GDA_ORG_LIST_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

Query

SQL_Statement

select distinct ORG_LIST.ORGANIZATION_ID from

(select 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

union all

select a.PRJ_ORGANIZATION_ID as ORGANIZATION_ID

from FUN_USER_ROLE_DATA_ASGNMNTS a, FND_SESSION_ROLE_SETS SROLE

where a.USER_GUID = FND_GLOBAL.USER_GUID

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

and a.ROLE_NAME = SROLE.ROLE_NAME

and SROLE.SESSION_ROLE_SET_KEY = FND_GLOBAL.SESSION_ROLE_SET_KEY

and a.PRJ_ORGANIZATION_ID is not null

) ORG_LIST