1. Tables and Views
  2. PSC_CE_TECH_CASE_V

PSC_CE_TECH_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.REVIEWER_ID PERSON_ID

FROM

PSC_CE_CASE C

UNION ALL

SELECT

J.CASE_KEY,

J.PERSON_ID

FROM

PSC_CE_JOB_ISTYP_CASE_V J

WHERE

J.JOB_FUNC_ID = 'ORA_CODE_ENFORCEMENT_TECHNICIAN'