1. Tables and Views
  2. PSC_CE_JOB_ISTYP_CASE_V

PSC_CE_JOB_ISTYP_CASE_V

Details

  • Schema: FUSION

  • Object owner: PSC_CE

  • Object type: VIEW

Columns

Name

JOB_FUNC_ID

PERSON_ID

CASE_KEY

Query

SQL_Statement

SELECT

P.JOB_FUNC_ID,

P.PERSON_ID,

C.CASE_KEY

FROM

PSC_COM_JOBSECTN_PROF_GRP_V P

JOIN PSC_CE_CASE C

ON (P.JOB_FUNC_SEC_ID = 'ORA_PSC_CE_ISSUE_TYPE'

AND C.ISSUE_TYPE_ID = NVL (P.JOB_FUNC_SECTN_VALUE, C.ISSUE_TYPE_ID))

OR (P.JOB_FUNC_SEC_ID = 'ORA_PSC_CE_ISSUE_SUBTYPE'

AND C.ISSUE_SUBTYPE_ID = NVL (P.JOB_FUNC_SECTN_VALUE, C.ISSUE_SUBTYPE_ID))