1. Tables and Views
  2. PSC_CE_OFFCR_CASE_V

PSC_CE_OFFCR_CASE_V

Details

  • Schema: FUSION

  • Object owner: PSC_CE

  • Object type: VIEW

Columns

Name

CASE_KEY

PERSON_ID

Query

SQL_Statement

SELECT

C.CASE_KEY,

C.ASSIGNED_ID PERSON_ID

FROM

PSC_CE_CASE C

UNION ALL

SELECT

J.CASE_KEY,

J.PERSON_ID

FROM

PSC_CE_JOB_DIST_CASE_V J

WHERE

J.JOB_FUNC_ID = 'ORA_CODE_ENFORCEMENT_OFFICER'