PSC_CE_SUPV_CASE_V

Details

• Schema: FUSION

• Object owner: PSC_CE

• Object type: VIEW

Columns

Name
CASE_KEY PERSON_ID

Query

SQL_Statement
SELECT J.CASE_KEY, J.PERSON_ID FROM PSC_CE_JOB_ISTYP_CASE_V J WHERE J.JOB_FUNC_ID = 'ORA_CODE_ENFORCEMENT_SUPERVISOR'