1. Tables and Views for Project Management
  2. GMS_AWARD_CREDIT_ORG_ALL_V

GMS_AWARD_CREDIT_ORG_ALL_V

Details

  • Schema: FUSION

  • Object owner: GMS

  • Object type: VIEW

Columns

Name

ORGANIZATION_ID

NAME

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

Query

SQL_Statement

SELECT DISTINCT haof.organization_id,

haotl.name,

haof.EFFECTIVE_START_DATE,

haof.EFFECTIVE_END_DATE

FROM HR_ALL_ORGANIZATION_UNITS_F haof,

HR_ORGANIZATION_UNITS_F_TL haotl,

HR_ORG_UNIT_CLASSIFICATIONS_F ouc

WHERE haof.ORGANIZATION_ID = haotl.ORGANIZATION_ID

AND haotl.LANGUAGE = USERENV('LANG')

AND haotl.EFFECTIVE_START_DATE = haof.EFFECTIVE_START_DATE

AND haotl.EFFECTIVE_END_DATE = haof.EFFECTIVE_END_DATE

AND haof.ORGANIZATION_ID = ouc.ORGANIZATION_ID

AND TRUNC(haof.EFFECTIVE_START_DATE) BETWEEN TRUNC(ouc.EFFECTIVE_START_DATE) AND TRUNC(ouc.EFFECTIVE_END_DATE)

AND ouc.classification_code IN ('PA_PROJECT_ORG','DEPARTMENT')

AND TRUNC(SYSDATE) BETWEEN TRUNC(haof.EFFECTIVE_START_DATE) AND TRUNC(haof.EFFECTIVE_END_DATE)