DBA Data[Home] [Help]

APPS.OKL_ACC_CALL_PVT dependencies on OKL_TXL_AR_INV_LNS_V

Line 340: FROM okl_txl_ar_inv_lns_v LN,

336: LN.kle_id,
337: LN.til_id_reverses,
338: -- Bug# 4488818
339: LN.qte_line_id
340: FROM okl_txl_ar_inv_lns_v LN,
341: okl_trx_ar_invoices_v hd,
342: okl_k_headers_v khr
343: WHERE hd.id = LN.Tai_id AND
344: khr.id = hd.khr_id AND

Line 370: FROM okl_txl_ar_inv_lns_v LN,

366: --Bug# 4488818
367: dtls.tld_id_reverses,
368: -- Bug# 4488818
369: LN.qte_line_id
370: FROM okl_txl_ar_inv_lns_v LN,
371: okl_trx_ar_invoices_v hd,
372: okl_txd_ar_ln_dtls_v dtls,
373: okl_k_headers_v khr
374: WHERE hd.id = LN.Tai_id AND

Line 395: l_rounded_amount okl_txl_ar_inv_lns_v.amount%type;

391:
392: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
393: l_precision fnd_currencies.precision%TYPE;
394: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
395: l_rounded_amount okl_txl_ar_inv_lns_v.amount%type;
396: l_sob_id okl_ext_sell_invs_v.SET_OF_BOOKS_ID%TYPE;
397: l_curr_code GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
398: l_trx_name VARCHAR2(20);
399:

Line 1761: FROM okl_txl_ar_inv_lns_v LN,

1757: LN.kle_id,
1758: LN.til_id_reverses,
1759: -- Bug# 4488818
1760: LN.qte_line_id
1761: FROM okl_txl_ar_inv_lns_v LN,
1762: okl_trx_ar_invoices_v hd,
1763: okl_k_headers_v khr
1764: WHERE hd.id = LN.Tai_id AND
1765: khr.id = hd.khr_id AND

Line 1791: FROM okl_txl_ar_inv_lns_v LN,

1787: --Bug# 4488818
1788: dtls.tld_id_reverses,
1789: -- Bug# 4488818
1790: LN.qte_line_id
1791: FROM okl_txl_ar_inv_lns_v LN,
1792: okl_trx_ar_invoices_v hd,
1793: okl_txd_ar_ln_dtls_v dtls,
1794: okl_k_headers_v khr
1795: WHERE hd.id = LN.Tai_id AND

Line 1816: l_rounded_amount okl_txl_ar_inv_lns_v.amount%type;

1812:
1813: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
1814: l_precision fnd_currencies.precision%TYPE;
1815: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
1816: l_rounded_amount okl_txl_ar_inv_lns_v.amount%type;
1817: l_sob_id okl_ext_sell_invs_v.SET_OF_BOOKS_ID%TYPE;
1818: l_curr_code GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
1819: l_trx_name VARCHAR2(20);
1820: