SELECT distinct aia.invoice_id, aia.invoice_num, aia.invoice_date, aia.invoice_amount, aia.invoice_currency_code, aia.payment_currency_code, aia.gl_date, xah.period_name, aia.payment_method_code, xah.je_category_name, xev.event_id, xte.ENTITY_CODE ,xte.APPLICATION_ID ,xte.legal_entity_id ,source_id_int_1 ...
DECLAREp_event_source_info xla_events_pub_pkg.t_event_source_info;lv_valuation_method VARCHAR2(100) :=null;lv_security_context xla_events_pub_pkg.t_security;BEGINp_event_source_info.source_application_id := 200; --101 GL -- 602 XLEp_event_source_info.application_id := 200; -- ARp_event_source_info.legal_entity_id := 23273;p_event_source_info.ledger_id := 2021;p_event_source_info.entity_type_code := 'AP_INVOICES';p_event_source_info.transaction_number := NULL;p_event_source_info.source_id_int_1 ...
