PSC_CE_CASE_INCUPD_TML_V

Details

• Schema: FUSION

• Object owner: PSC_CE

• Object type: VIEW

Columns

Name
TIMELINE_KEY CASE_KEY EVENT_TYPE EVENT_DATETIME ATTR_1 ATTR_2 ATTR_3 ATTR_4 ATTR_5 ATTR_6 SPREADSHEETTITLE SPREADSHEETSUMMARY SPREADSHEETDETAIL

Query

SQL_Statement

SELECT to_char(ir.incident_key) timeline_key, ir.case_key, 'ORA_INC_UPDATE' event_type, ir.submit_date event_datetime, ir.issue_type attr_1, ir.issue_subtype attr_2, ir.reported_by attr_3, ir.issue_description attr_4, to_char(ir.att_xref_key) attr_5, NULL attr_6, fnd.meaning spreadsheettitle, ir.issue_type || ' | ' || ir.issue_subtype || ' | ' || ir.reported_by spreadsheetsummary, ir.issue_description spreadsheetdetail FROM ( SELECT cs.case_key, inc.incident_key, inc.incident_id, inc.submit_date, it.issue_type, ist.issue_subtype, inc.issue_description, xref.att_xref_key, CASE WHEN inc.agency_flag = 'Y' THEN CASE WHEN intk.anonymous_flag = 'Y' THEN ( SELECT per.display_name FROM per_person_names_f per WHERE per.person_id = inc.reported_by_id AND per.name_type = 'GLOBAL' AND trunc(sysdate) between per.effective_start_date and per.effective_end_date ) WHEN intk.anonymous_flag = 'N' THEN intk.compn_first_name ELSE NULL END WHEN intk.anonymous_flag = 'N' THEN intk.compn_first_name ELSE NULL END AS "REPORTED_BY" FROM psc_ce_incident inc, psc_ce_case cs, psc_ce_intake intk LEFT OUTER JOIN psc_ce_intk_att_xref xref ON xref.att_xref_trans_key = intk.att_xref_trans_key, psc_ce_issue_type_vl it, psc_ce_issue_subtype_vl ist WHERE inc.intake_key = intk.intake_key AND cs.intake_source = 'ORA_INC' AND cs.source_trx_id = inc.incident_key AND it.issue_type_id = inc.issue_type_id AND ist.issue_subtype_id = inc.issue_subtype_id ) ir, fnd_lookup_values_vl fnd WHERE fnd.lookup_type = 'ORA_PSC_CE_CASE_TIMELINE_EVT' AND fnd.lookup_code = 'ORA_INC_UPDATE' AND fnd.view_application_id = 10554