APPS.OKL_ARFETCH_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 48: FROM ra_customer_trx_lines_all trx,

44: lln.id lln_id,
45: cnr.consolidated_invoice_number,
46: sty.name sty_name,
47: lsm.amount lsm_amount
48: FROM ra_customer_trx_lines_all trx,
49: okl_cnsld_ar_strms_b lsm,
50: okl_cnsld_ar_lines_b lln,
51: okl_cnsld_ar_hdrs_b cnr,
52: okl_xtl_sell_invs_b xls,

Line 85: FROM ra_customer_trx_lines

81: -- Cursor to fetch tax amounts for an AR invoice
82: -- ----------------------------------------------
83: CURSOR ar_tax_csr ( p_cust_trx_id NUMBER ) IS
84: SELECT SUM(NVL( extended_amount ,0))
85: FROM ra_customer_trx_lines
86: WHERE customer_trx_id = p_cust_trx_id AND
87: LINE_TYPE = 'TAX';
88:
89: