DBA Data[Home] [Help]

APPS.OKL_BILLING_RECON_RPT_PVT dependencies on RA_INTERFACE_ERRORS_ALL

Line 345: ra_interface_errors_all err

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)