SELECT
fnint.party_orig_system_reference fnposr,
fnint.type_of_financial_report fn_rep_type,
fnint.document_reference fn_doc_ref,
fnint.date_report_issued fn_dt_rep_issued,
fnint.issued_period fn_issued_period,
fnint.report_start_date fn_rep_st_dt,
fnint.report_end_date fn_rep_end_dt,
fnint.financial_number_name fn_fin_no_name,
HZ_UTILITY_V2PUB.get_message('AR',e.message_name,
e.TOKEN1_NAME, e.TOKEN1_VALUE, e.TOKEN2_NAME, e.TOKEN2_VALUE,
e.TOKEN3_NAME, e.TOKEN3_VALUE, e.TOKEN4_NAME, e.TOKEN4_VALUE,
e.TOKEN5_NAME, e.TOKEN5_VALUE) fnint_error_message
FROM HZ_IMP_ERRORS e, HZ_IMP_FINNUMBERS_INT fnint
WHERE fnint.ERROR_ID = e.ERROR_ID
AND e.batch_id = fnint.batch_id
AND fnint.INTERFACE_STATUS = 'E'
AND fnint.party_orig_system = :p_orig_sys
AND e.interface_table_name = 'HZ_IMP_FINNUMBERS_INT'
AND e.batch_id = :p_batch_id |
