PSC_CE_JOB_DIST_INCIDENT_V

Details

• Schema: FUSION

• Object owner: PSC_CE

• Object type: VIEW

Columns

Name
JOB_FUNC_ID PERSON_ID INCIDENT_KEY

Query

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