341: trx_date due_date,
342: err.MESSAGE_TEXT remarks
343: FROM ra_interface_lines_all hdr,
344: RA_CUST_TRX_TYPES_ALL trx_type,
345: ra_interface_errors_all err
346: WHERE hdr.batch_source_name = 'OKL_CONTRACTS'
347: AND hdr.CUST_TRX_TYPE_ID = trx_type.CUST_TRX_TYPE_ID
348: AND hdr.INTERFACE_LINE_ATTRIBUTE6 =
349: NVL(rtrim(ltrim( p_in_contract_number)),hdr.INTERFACE_LINE_ATTRIBUTE6)