PSC_CE_CASE_APPEAL_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 'ORA_APL_' || to_char(a.case_appeal_key) timeline_key, a.case_key, 'ORA_APPEAL' event_type, a.creation_date event_datetime, rtrim(b.person_first_name || ' ' || b.person_last_name) attr_1, a.appeal_reason attr_2, NULL attr_3, NULL attr_4, NULL attr_5, NULL attr_6, fnd.meaning spreadsheettitle, rtrim(b.person_first_name || ' ' || b.person_last_name) spreadsheetsummary, a.appeal_reason spreadsheetdetail FROM psc_ce_case_appeal a LEFT JOIN psc_ce_case_contact b ON b.case_contact_key = a.resp_contact_key JOIN fnd_lookup_values_vl fnd ON fnd.lookup_type = 'ORA_PSC_CE_CASE_TIMELINE_EVT' AND fnd.lookup_code = 'ORA_APPEAL' AND fnd.view_application_id = 10554 WHERE a.appeal_src = 'ORA_APL' AND a.classification = 'ORA_CE'