APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 3037: l_bpd_acc_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';

3033: RAISE Okl_Api.G_EXCEPTION_ERROR;
3034: END IF;
3035:
3036: l_bpd_acc_rec.id := r_tldv_rec.id;
3037: l_bpd_acc_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';
3038: ----------------------------------------------------
3039: -- Create Accounting Distributions
3040: ----------------------------------------------------
3041: Okl_Acc_Call_Pub.CREATE_ACC_TRANS(

Line 4278: FROM okl_txd_ar_ln_dtls_b tld,

4274: p_start_date DATE,
4275: p_due_date DATE) IS
4276: SELECT cra.receipt_date receipt_date
4277: ,SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) principal_pmt_rcpt_amt -- 4884843, 4872370
4278: FROM okl_txd_ar_ln_dtls_b tld,
4279: ra_customer_trx_lines_all ractrl,
4280: okl_txl_ar_inv_lns_b til,
4281: okl_trx_ar_invoices_b tai,
4282: ar_payment_schedules_all aps,

Line 4309: FROM okl_txd_ar_ln_dtls_b tld,

4305: GROUP BY cra.receipt_date
4306: UNION ALL
4307: SELECT cra.receipt_date receipt_date
4308: ,SUM(raa.line_applied) principal_pmt_rcpt_amt -- 4884843, 4872370
4309: FROM okl_txd_ar_ln_dtls_b tld,
4310: ra_customer_trx_lines_all ractrl,
4311: okl_txl_ar_inv_lns_b til,
4312: okl_trx_ar_invoices_b tai,
4313: ar_payment_schedules_all aps,

Line 7098: l_bpd_acc_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';

7094: RAISE create_stream_invoice_failed;
7095: END IF;
7096:
7097: l_bpd_acc_rec.id := r_tldv_rec.id;
7098: l_bpd_acc_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';
7099:
7100: Okl_Acc_Call_Pub.CREATE_ACC_TRANS(
7101: p_api_version,
7102: p_init_msg_list,

Line 7837: FROM okl_txd_ar_ln_dtls_b tld

7833: --Bug# 6819044: Fetch receipt applications correctly when
7834: -- invoices have lines from multiple contracts
7835: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7836: SELECT 'Y' return_value
7837: FROM okl_txd_ar_ln_dtls_b tld
7838: ,ra_customer_trx_lines_all ractrl
7839: ,okl_txl_ar_inv_lns_b til
7840: ,okl_trx_ar_invoices_b tai
7841: ,ar_payment_schedules_all aps

Line 8130: FROM okl_txd_ar_ln_dtls_b tld

8126: -- a contract
8127: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8128: SELECT DISTINCT raa.receivable_application_id source_id
8129: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table
8130: FROM okl_txd_ar_ln_dtls_b tld
8131: ,ra_customer_trx_lines_all ractrl
8132: ,okl_txl_ar_inv_lns_b til
8133: ,okl_trx_ar_invoices_b tai
8134: ,ar_payment_schedules_all aps