DBA Data[Home] [Help]

APPS.OKL_BILLING_RECON_RPT_PVT dependencies on RA_INTERFACE_LINES_ALL

Line 134: FROM ra_interface_lines_all hdr,

130: CURSOR intf_summary_csr( p_in_contract_number VARCHAR2, p_currency_code VARCHAR2) IS
131: SELECT count(*) cnt,
132: SUM(AMOUNT) Invoice_amt,
133: hdr.currency_code
134: FROM ra_interface_lines_all hdr,
135: RA_CUST_TRX_TYPES_ALL trx_type
136: WHERE hdr.CUST_TRX_TYPE_ID = trx_type.CUST_TRX_TYPE_ID
137: AND hdr.currency_code = p_currency_code
138: AND hdr.batch_source_name = 'OKL_CONTRACTS'

Line 265: -- Unprocessed, stuck in ra_interface_lines_all

261: --decode(trx_type.TYPE,'INV','Invoice','CM','Credit Memo')
262: ORDER BY 3;
263:
264: -- ---------------------------------------------
265: -- Unprocessed, stuck in ra_interface_lines_all
266: -- ---------------------------------------------
267: CURSOR ar_interface_invs_csr( p_in_contract_number VARCHAR2
268: ,p_in_from_bill_date DATE
269: ,p_in_to_bill_date DATE

Line 276: FROM ra_interface_lines_all hdr,

272: SUM(AMOUNT) Invoice_amt,
273: hdr.currency_code,
274: interface_line_attribute6--,
275: --decode(trx_type.TYPE,'INV','Invoice','CM','Credit Memo') Invoice_Type
276: FROM ra_interface_lines_all hdr,
277: RA_CUST_TRX_TYPES_ALL trx_type
278: WHERE hdr.batch_source_name = 'OKL_CONTRACTS'
279: AND hdr.CUST_TRX_TYPE_ID = trx_type.CUST_TRX_TYPE_ID
280: AND hdr.INTERFACE_LINE_ATTRIBUTE6 =

Line 343: FROM ra_interface_lines_all hdr,

339: INTERFACE_LINE_ATTRIBUTE9 stream_type,
340: decode(trx_type.TYPE,'INV','Invoice','CM','Credit Memo') Invoice_Type,
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