PSC_CE_OFFCR_DTYPE_CASE_V

Details

• Schema: FUSION

• Object owner: PSC_CE

• Object type: VIEW

Columns

Name
CASE_KEY PERSON_ID

Query

SQL_Statement

SELECT OC.CASE_KEY, OC.PERSON_ID FROM PSC_CE_OFFCR_CASE_V OC UNION ALL SELECT C.CASE_KEY, J.PERSON_ID FROM PSC_COM_JOBSECTN_PROF_GRP_V J JOIN PSC_COM_DISTRICT_VL D ON D.DISTRICT_ID = J.JOB_FUNC_SECTN_VALUE JOIN PSC_CE_CASE C ON C.DISTRICT_TYPE = D.DISTRICT_TYPE WHERE J.JOB_FUNC_SEC_ID = 'ORA_PSC_CE_DISTRICTS' UNION ALL SELECT CS.CASE_KEY, PE.PERSON_ID FROM PSC_CE_CASE CS, PSC_COM_JOBSECTN_PROF_GRP_V PE WHERE CS.DISTRICT_TYPE IS NULL