APPS.OKL_BILLING_RECON_RPT_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 29: CONTRACT_NUMBER okl_k_headers_full_v.contract_number%TYPE,

25: -- ----------------------------------------------------------
26: -- Record Type for reconciliation report format
27: -- ----------------------------------------------------------
28: TYPE recon_fmt_rec_type IS RECORD (
29: CONTRACT_NUMBER okl_k_headers_full_v.contract_number%TYPE,
30: currency_code fnd_currencies_vl.currency_code%TYPE,
31: okl_count NUMBER,
32: okl_amount NUMBER,
33: ar_count NUMBER,

Line 67: okl_k_headers_full_v khr

63: okl_txl_ar_inv_lns_v til,
64: okl_txd_ar_ln_dtls_v tld,
65: okl_ext_sell_invs_v xsi,
66: okl_xtl_sell_invs_v xls,
67: okl_k_headers_full_v khr
68: WHERE tai.id = til.tai_id
69: AND til.id = tld.til_id_details
70: AND xsi.id = xls.xsi_id_details
71: AND xls.tld_id = tld.id

Line 91: okl_k_headers_full_v khr

87: FROM okl_ext_sell_invs_v xsi,
88: okl_xtl_sell_invs_v xls,
89: okl_trx_ar_invoices_v tai,
90: okl_txl_ar_inv_lns_v til,
91: okl_k_headers_full_v khr
92: WHERE tai.id = til.tai_id
93: AND xsi.id = xls.xsi_id_details
94: AND xls.til_id = til.id
95: AND xsi.currency_code = p_currency_code

Line 150: FROM OKL_K_HEADERS_FULL_V

146: -- Contract Number Cursor
147: ------------------------------------------------------------
148: CURSOR khr_csr ( p_contract_number VARCHAR2 ) IS
149: SELECT *
150: FROM OKL_K_HEADERS_FULL_V
151: WHERE contract_number = NVL( p_contract_number, contract_number );
152:
153: ------------------------------------------------------------
154: -- OKL Generated Invoices

Line 294: l_okl_currency_code okl_k_headers_full_v.currency_code%TYPE;

290:
291: ------------------------------------------------------
292: -- Local Variables
293: ------------------------------------------------------
294: l_okl_currency_code okl_k_headers_full_v.currency_code%TYPE;
295: l_okl_contract okl_k_headers_full_v.contract_number%TYPE;
296: l_okl_invoice_count NUMBER;
297: l_okl_invoice_amount NUMBER;
298:

Line 295: l_okl_contract okl_k_headers_full_v.contract_number%TYPE;

291: ------------------------------------------------------
292: -- Local Variables
293: ------------------------------------------------------
294: l_okl_currency_code okl_k_headers_full_v.currency_code%TYPE;
295: l_okl_contract okl_k_headers_full_v.contract_number%TYPE;
296: l_okl_invoice_count NUMBER;
297: l_okl_invoice_amount NUMBER;
298:
299: l_okl_wo_currency_code okl_k_headers_full_v.currency_code%TYPE;

Line 299: l_okl_wo_currency_code okl_k_headers_full_v.currency_code%TYPE;

295: l_okl_contract okl_k_headers_full_v.contract_number%TYPE;
296: l_okl_invoice_count NUMBER;
297: l_okl_invoice_amount NUMBER;
298:
299: l_okl_wo_currency_code okl_k_headers_full_v.currency_code%TYPE;
300: l_okl_wo_contract okl_k_headers_full_v.contract_number%TYPE;
301: l_okl_wo_invoice_count NUMBER;
302: l_okl_wo_invoice_amount NUMBER;
303:

Line 300: l_okl_wo_contract okl_k_headers_full_v.contract_number%TYPE;

296: l_okl_invoice_count NUMBER;
297: l_okl_invoice_amount NUMBER;
298:
299: l_okl_wo_currency_code okl_k_headers_full_v.currency_code%TYPE;
300: l_okl_wo_contract okl_k_headers_full_v.contract_number%TYPE;
301: l_okl_wo_invoice_count NUMBER;
302: l_okl_wo_invoice_amount NUMBER;
303:
304: l_ar_currency_code okl_k_headers_full_v.currency_code%TYPE;

Line 304: l_ar_currency_code okl_k_headers_full_v.currency_code%TYPE;

300: l_okl_wo_contract okl_k_headers_full_v.contract_number%TYPE;
301: l_okl_wo_invoice_count NUMBER;
302: l_okl_wo_invoice_amount NUMBER;
303:
304: l_ar_currency_code okl_k_headers_full_v.currency_code%TYPE;
305: l_ar_contract okl_k_headers_full_v.contract_number%TYPE;
306: l_ar_invoice_count NUMBER;
307: l_ar_invoice_amount NUMBER;
308:

Line 305: l_ar_contract okl_k_headers_full_v.contract_number%TYPE;

301: l_okl_wo_invoice_count NUMBER;
302: l_okl_wo_invoice_amount NUMBER;
303:
304: l_ar_currency_code okl_k_headers_full_v.currency_code%TYPE;
305: l_ar_contract okl_k_headers_full_v.contract_number%TYPE;
306: l_ar_invoice_count NUMBER;
307: l_ar_invoice_amount NUMBER;
308:
309: l_int_currency_code okl_k_headers_full_v.currency_code%TYPE;

Line 309: l_int_currency_code okl_k_headers_full_v.currency_code%TYPE;

305: l_ar_contract okl_k_headers_full_v.contract_number%TYPE;
306: l_ar_invoice_count NUMBER;
307: l_ar_invoice_amount NUMBER;
308:
309: l_int_currency_code okl_k_headers_full_v.currency_code%TYPE;
310: l_int_contract okl_k_headers_full_v.contract_number%TYPE;
311: l_int_invoice_count NUMBER;
312: l_int_invoice_amount NUMBER;
313:

Line 310: l_int_contract okl_k_headers_full_v.contract_number%TYPE;

306: l_ar_invoice_count NUMBER;
307: l_ar_invoice_amount NUMBER;
308:
309: l_int_currency_code okl_k_headers_full_v.currency_code%TYPE;
310: l_int_contract okl_k_headers_full_v.contract_number%TYPE;
311: l_int_invoice_count NUMBER;
312: l_int_invoice_amount NUMBER;
313:
314: l_cnt_diff NUMBER;