DBA Data[Home] [Help]

APPS.OKL_ACC_CALL_PVT dependencies on OKL_K_HEADERS_V

Line 342: okl_k_headers_v khr

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
345: LN.ID = l_id;
346:

Line 373: okl_k_headers_v khr

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
375: LN.ID = dtls.til_id_details AND
376: khr.ID = hd.KHR_ID AND
377: dtls.ID = l_id;

Line 401: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;

397: l_curr_code GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
398: l_trx_name VARCHAR2(20);
399:
400: --Start code added by pgomes on 11/22/2002
401: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;
402: l_khr_id khr_id_type;
403: l_currency_code okl_ext_sell_invs_b.currency_code%type;
404: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
405: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;

Line 1763: okl_k_headers_v khr

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
1766: LN.ID = l_id;
1767:

Line 1794: okl_k_headers_v khr

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
1796: LN.ID = dtls.til_id_details AND
1797: khr.ID = hd.KHR_ID AND
1798: dtls.ID = l_id;

Line 1822: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;

1818: l_curr_code GL_LEDGERS_PUBLIC_V.currency_code%TYPE;
1819: l_trx_name VARCHAR2(20);
1820:
1821: --Start code added by pgomes on 11/22/2002
1822: SUBTYPE khr_id_type IS okl_k_headers_v.khr_id%type;
1823: l_khr_id khr_id_type;
1824: l_currency_code okl_ext_sell_invs_b.currency_code%type;
1825: l_currency_conversion_type okl_ext_sell_invs_b.currency_conversion_type%type;
1826: l_currency_conversion_rate okl_ext_sell_invs_b.currency_conversion_rate%type;