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_AM_ASSET_DISPOSE_PVT dependencies on OKL_K_HEADERS

Line 56: okl_k_headers khr,

52: khr.id,
53: chrb.scs_code, -- rmunjulu 4622198
54: chrb.org_id --added by akrangan to get the org_id of the contract
55: FROM okc_k_headers_b chrb,
56: okl_k_headers khr,
57: okc_k_lines_b okc
58: WHERE okc.id = p_kle_id
59: AND khr.id = chrb.id
60: AND okc.chr_id = chrb.id;

Line 82: FROM okl_k_headers okl

78: attribute12,
79: attribute13,
80: attribute14,
81: attribute15
82: FROM okl_k_headers okl
83: WHERE okl.id = p_khr_id;
84: --line dff fields cursor
85: --this cursor is to populate the
86: -- desc flex fields columns in okl_txl_xontract_lines_b

Line 164: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

160: --local variables and types declared here
161: l_org_id NUMBER(15);
162: l_currency_code okl_trx_contracts.currency_code%TYPE;
163: l_contract_currency okl_trx_contracts.currency_code%TYPE;
164: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
165: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
166: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
167: l_amount NUMBER;
168: l_total_trx_amount NUMBER;

Line 165: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

161: l_org_id NUMBER(15);
162: l_currency_code okl_trx_contracts.currency_code%TYPE;
163: l_contract_currency okl_trx_contracts.currency_code%TYPE;
164: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
165: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
166: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
167: l_amount NUMBER;
168: l_total_trx_amount NUMBER;
169: l_validity_date DATE;

Line 166: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

162: l_currency_code okl_trx_contracts.currency_code%TYPE;
163: l_contract_currency okl_trx_contracts.currency_code%TYPE;
164: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
165: l_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
166: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
167: l_amount NUMBER;
168: l_total_trx_amount NUMBER;
169: l_validity_date DATE;
170: --trx contracts specific tbl types

Line 1850: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr

1846:
1847: -- get the deal type from the contract
1848: CURSOR l_dealtype_csr(p_financial_asset_id IN NUMBER) IS
1849: SELECT lkhr.id, lkhr.deal_type, khr.contract_number
1850: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr
1851: WHERE khr.id = cle.chr_id
1852: AND lkhr.id = khr.id
1853: AND cle.id = p_financial_asset_id;
1854:

Line 3671: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr

3667:
3668: -- get the deal type from the contract
3669: CURSOR l_dealtype_csr(p_financial_asset_id IN NUMBER) IS
3670: SELECT lkhr.id, lkhr.deal_type, khr.contract_number
3671: FROM okl_k_headers lkhr, okc_k_lines_b cle, okc_k_headers_b khr
3672: WHERE khr.id = cle.chr_id
3673: AND lkhr.id = khr.id
3674: AND cle.id = p_financial_asset_id;
3675: