PSC_CE_CASE_PAYMNT_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(fr.payment_history_key) timeline_key, fr.case_key, 'ORA_PAYMENT' event_type, fr.payment_date event_datetime, to_char(fr.payment_history_key) attr_1, to_char(fr.party_id) attr_2, fr.payer_name attr_3, NULL attr_4, NULL attr_5, NULL attr_6, fnd.meaning spreadsheettitle, fr.payer_name spreadsheetsummary, ( SELECT rtrim(sys.stragg(item_description || ': ' || item_unit_price || ' ' || item_currency || ' | '), ' | ') FROM psc_bnp_payment_hist_lin WHERE payment_history_key = fr.payment_history_key GROUP BY payment_history_key ) spreadsheetdetail FROM ( SELECT f.payment_history_key, f.case_key, MAX(h.authorization_dttm) payment_date, MAX(h.party_id) party_id, MAX(TRIM(h.payer_first_name || ' ' || h.payer_last_name)) payer_name FROM psc_ce_fee_record f, psc_bnp_payment_hist_hdr h WHERE f.fee_status = 'ORA_PAID' AND h.payment_history_key = f.payment_history_key GROUP BY f.case_key, f.payment_history_key ) fr, fnd_lookup_values_vl fnd WHERE fnd.lookup_type = 'ORA_PSC_CE_CASE_TIMELINE_EVT' AND fnd.lookup_code = 'ORA_PAYMENT' AND fnd.view_application_id = 10554