APPS.OKL_CASH_RECEIPT dependencies on RA_CUSTOMER_TRX_ALL

Line 57: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;

53: l_orig_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
54: l_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
55: l_functional_currency OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL;
56:
57: ar_invoice_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
58: ar_invoice_date OKL_BPD_LEASING_PAYMENT_TRX_V.INVOICE_DATE%TYPE DEFAULT NULL;
59:
60: l_inv_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
61: l_rec_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;

Line 217: FROM ra_customer_trx_all

213: FROM okl_cnsld_ar_strms_v
214: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
215:
216: SELECT bill_to_site_use_id INTO l_customer_site_use_id
217: FROM ra_customer_trx_all
218: WHERE customer_trx_id = l_customer_trx_id;
219:
220: l_customer_trx_id := NULL;
221:

Line 821: FROM ra_customer_trx_all

817: FROM okl_cnsld_ar_strms_v
818: WHERE okl_cnsld_ar_strms_v.id = l_xcav_tbl(i).lsm_id;
819:
820: SELECT bill_to_site_use_id INTO l_customer_site_use_id
821: FROM ra_customer_trx_all
822: WHERE customer_trx_id = l_customer_trx_id;
823:
824: -- l_customer_trx_id := NULL;
825: