1. Tables and Views for Project Management
  2. PJF_ORGANIZATIONS_EXPEND_V

PJF_ORGANIZATIONS_EXPEND_V

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

ORG_ID

ORGANIZATION_ID

NAME

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

ACTIVE_FLAG

Query

SQL_Statement

SELECT PJFORG.ORG_ID

,HRORG.ORGANIZATION_ID

, HRORG.NAME

, HRORG.EFFECTIVE_START_DATE

, HRORG.EFFECTIVE_END_DATE

, CASE WHEN (PJFORG.INACTIVE_DATE IS NULL) THEN 'Y'

WHEN (PJFORG.INACTIVE_DATE IS NOT NULL) THEN 'N'

END ACTIVE_FLAG

FROM HR_ORGANIZATION_V HRORG

, PJF_ALL_ORGANIZATIONS PJFORG

WHERE PJFORG.ORGANIZATION_ID = HRORG.ORGANIZATION_ID

AND PJFORG.PA_ORG_USE_TYPE = 'EXPENDITURES'

AND HRORG.CLASSIFICATION_CODE = 'PA_EXPENDITURE_ORG'