PSC_CE_JOB_DIST_CASE_V

Details

• Schema: FUSION

• Object owner: PSC_CE

• Object type: VIEW

Columns

Name
JOB_FUNC_ID PERSON_ID CASE_KEY

Query

SQL_Statement
SELECT P.JOB_FUNC_ID, P.PERSON_ID, C.CASE_KEY FROM PSC_COM_JOBSECTN_PROF_GRP_V P JOIN PSC_CE_CASE C ON (P.JOB_FUNC_SEC_ID = 'ORA_PSC_CE_DISTRICT_TYPES' AND NVL (C.DISTRICT_TYPE, ' ') = NVL (P.JOB_FUNC_SECTN_VALUE, NVL (C.DISTRICT_TYPE, ' '))) OR (P.JOB_FUNC_SEC_ID = 'ORA_PSC_CE_DISTRICTS' AND NVL (C.DISTRICT_ID, ' ') = NVL (P.JOB_FUNC_SECTN_VALUE, NVL (C.DISTRICT_ID, ' ')))