1. Tables and Views for Project Management
  2. PJF_PROJECT_ORG_BUPU_V

PJF_PROJECT_ORG_BUPU_V

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

ORG_ID

ORGANIZATION_ID

NAME

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

CLASSIFICATION_CODE

OBJECT_VERSION_NUMBER

ORGANIZATION_ID1

PA_ORG_USE_TYPE

OBJECT_VERSION_NUMBER2

ORG_INFORMATION11

ORG_INFORMATION_ID1

CLASSIFICATION_CODE2

ORG_INFORMATION12

ORG_INFORMATION13

EFFECTIVE_START_DATE2

EFFECTIVE_END_DATE2

Query

SQL_Statement

SELECT PjfAllOrganizations.ORG_ID,

OrganizationDPEO.ORGANIZATION_ID,

OrganizationDPEO.NAME,

OrganizationDPEO.EFFECTIVE_START_DATE,

OrganizationDPEO.EFFECTIVE_END_DATE,

OrganizationDPEO.CLASSIFICATION_CODE,

OrganizationDPEO.OBJECT_VERSION_NUMBER,

PjfAllOrganizations.ORGANIZATION_ID AS ORGANIZATION_ID1,

PjfAllOrganizations.PA_ORG_USE_TYPE,

PjfAllOrganizations.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER2,

OrganizationDetailDPEO1.ORG_INFORMATION1 AS ORG_INFORMATION11,

OrganizationDetailDPEO1.ORG_INFORMATION_ID AS ORG_INFORMATION_ID1,

OrganizationDetailDPEO1.CLASSIFICATION_CODE AS CLASSIFICATION_CODE2,

OrganizationDetailDPEO1.ORG_INFORMATION12,

OrganizationDetailDPEO1.ORG_INFORMATION13,

OrganizationDetailDPEO1.EFFECTIVE_START_DATE AS EFFECTIVE_START_DATE2,

OrganizationDetailDPEO1.EFFECTIVE_END_DATE AS EFFECTIVE_END_DATE2

FROM HR_ORGANIZATION_V OrganizationDPEO, PJF_ALL_ORGANIZATIONS PjfAllOrganizations, HR_ORG_DETAILS_BY_CLASS_V OrganizationDetailDPEO1

WHERE OrganizationDPEO.CLASSIFICATION_CODE = 'PA_PROJECT_ORG'

AND (trunc(SYSDATE) BETWEEN OrganizationDPEO.EFFECTIVE_START_DATE AND OrganizationDPEO.EFFECTIVE_END_DATE)

AND (trunc(SYSDATE) BETWEEN OrganizationDetailDPEO1.EFFECTIVE_START_DATE AND OrganizationDetailDPEO1.EFFECTIVE_END_DATE)

AND PjfAllOrganizations.INACTIVE_DATE IS NULL

AND PjfAllOrganizations.ORGANIZATION_ID = OrganizationDPEO.ORGANIZATION_ID

AND PjfAllOrganizations.PA_ORG_USE_TYPE = 'PROJECTS'

AND OrganizationDetailDPEO1.ORGANIZATION_ID = OrganizationDPEO.ORGANIZATION_ID

AND OrganizationDetailDPEO1.ORG_INFORMATION_CONTEXT = 'Project Type Class Information'

AND OrganizationDetailDPEO1.CLASSIFICATION_CODE = OrganizationDPEO.CLASSIFICATION_CODE

ORDER BY OrganizationDPEO.NAME