DBA Data[Home] [Help]

APPS.OKL_BILLING_RECON_RPT_PVT dependencies on RA_BATCH_SOURCES_ALL

Line 113: ra_batch_sources_all batch,

109: SUM(NVL(line.EXTENDED_AMOUNT,0)) Invoice_Amount,
110: hdr.invoice_currency_code
111: FROM ra_customer_trx_all hdr,
112: ra_customer_trx_lines_all line,
113: ra_batch_sources_all batch,
114: RA_CUST_TRX_TYPES_ALL trx_type
115: WHERE line.customer_trx_id = hdr.customer_trx_id
116: AND hdr.batch_source_id = batch.batch_source_id
117: AND batch.name = 'OKL_CONTRACTS'

Line 246: ra_batch_sources_all batch,

242: hdr.INTERFACE_HEADER_ATTRIBUTE6 Contract_Number--,
243: -- decode(trx_type.TYPE,'INV','Invoice','CM','Credit Memo') Invoice_Type
244: FROM ra_customer_trx_all hdr,
245: ra_customer_trx_lines_all line,
246: ra_batch_sources_all batch,
247: RA_CUST_TRX_TYPES_ALL trx_type
248: WHERE line.customer_trx_id = hdr.customer_trx_id
249: AND hdr.batch_source_id = batch.batch_source_id
250: AND batch.name = 'OKL_CONTRACTS'