eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_K_HEADERS

Line 192: ,okl_k_headers_full_v khr

188: ,khr.currency_conversion_date currency_conversion_date
189: --Bug# 4622198
190: ,khr.scs_code
191: FROM okl_products_v pdt
192: ,okl_k_headers_full_v khr
193: WHERE khr.id = p_contract_id
194: AND khr.pdt_id = pdt.id;
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

Line 196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

192: ,okl_k_headers_full_v khr
193: WHERE khr.id = p_contract_id
194: AND khr.pdt_id = pdt.id;
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

193: WHERE khr.id = p_contract_id
194: AND khr.pdt_id = pdt.id;
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
201:

Line 198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

194: AND khr.pdt_id = pdt.id;
195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
201:
202: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS

Line 199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

195:
196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
201:
202: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
203: SELECT id trx_try_id

Line 200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

196: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
197: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
198: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
199: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
200: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
201:
202: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
203: SELECT id trx_try_id
204: FROM okl_trx_types_tl

Line 2101: from okl_products a, okl_k_headers b

2097:
2098: -- racheruv .. R12.1.2 .. start
2099: select decode(reporting_pdt_id, NULL, NULL, 'Y')
2100: into lp_khrv_rec.multi_gaap_yn
2101: from okl_products a, okl_k_headers b
2102: where b.pdt_id = a.id
2103: and b.id = lp_chrv_rec.id;
2104: -- racheruv .. R12.1.2 end
2105: