PSC_CE_CASE_NOTICE_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(a.case_notice_key) timeline_key, a.case_key, 'ORA_NOTICE' event_type, a.generated_date event_datetime, a.case_notice_id attr_1, b.name attr_2, personnamedpeo.display_name attr_3, a.shipped_by attr_4, to_char(a.shipped_date, 'YYYY-MM-DD HH24:MI:SSXFF') attr_5, a.tracking_id attr_6, fnd.meaning spreadsheettitle, b.name || ' | ' || a.case_notice_id || ' | ' || personnamedpeo.display_name spreadsheetsummary, a.shipped_by || nvl2(a.shipped_by, ' | ' || a.tracking_id, a.tracking_id) || nvl2(a.tracking_id, ' | ' || to_char(a.shipped_date, 'YYYY-MM-DD HH24:MI:SSXFF'), to_char(a.shipped_date, 'YYYY-MM-DD HH24:MI:SSXFF' )) spreadsheetdetail FROM psc_ce_case_notice a, psc_ce_noticetype_vl b, fnd_lookup_values_vl fnd, per_person_names_f personnamedpeo, per_users users WHERE a.agency_id = b.agency_id AND a.notice_type_code = b.notice_type_code AND a.notice_status NOT IN ( 'ORA_CANC', 'ORA_HOLD', 'ORA_PEND', 'ORA_INPR' ) AND fnd.lookup_type = 'ORA_PSC_CE_CASE_TIMELINE_EVT' AND fnd.lookup_code = 'ORA_NOTICE' AND fnd.view_application_id = 10554 AND personnamedpeo.person_id = users.person_id AND trunc(sysdate) between personnamedpeo.effective_start_date and personnamedpeo.effective_end_date AND personnamedpeo.name_type = 'GLOBAL' AND users.username = a.last_updated_by