PJF_SECURED_ORGANIZATIONS_V

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
BU_ID PU_ID

Query

SQL_Statement

SELECT DISTINCT PJF_SECURED_ORGANIZATIONS.ORG_ID AS BU_ID, TO_NUMBER(HR_ORG_DETAILS_BY_CLASS_V.ORG_INFORMATION1) AS PU_ID FROM PJF_SECURED_ORGANIZATIONS, HR_ORG_DETAILS_BY_CLASS_V WHERE PJF_SECURED_ORGANIZATIONS.ORGANIZATION_ID= HR_ORG_DETAILS_BY_CLASS_V .ORGANIZATION_ID AND PJF_SECURED_ORGANIZATIONS.PA_ORG_USE_TYPE='PROJECTS' AND HR_ORG_DETAILS_BY_CLASS_V.ORG_INFORMATION_CONTEXT='Project Unit Information' AND HR_ORG_DETAILS_BY_CLASS_V.CLASSIFICATION_CODE = 'PA_PROJECT_ORG'