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

Line 1187: FROM OKL_K_HEADERS A,

1183: -- MGAAP start 7263041
1184: CURSOR check_csr(p_chr_id NUMBER) IS
1185: SELECT A.MULTI_GAAP_YN,
1186: B.REPORTING_PDT_ID
1187: FROM OKL_K_HEADERS A,
1188: OKL_PRODUCTS B
1189: WHERE A.ID = p_chr_id
1190: AND A.PDT_ID = B.ID;
1191:

Line 1192: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

1188: OKL_PRODUCTS B
1189: WHERE A.ID = p_chr_id
1190: AND A.PDT_ID = B.ID;
1191:
1192: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
1193: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
1194: -- MGAAP start 7263041
1195:
1196: --Bug# 9191475

Line 1683: ,okl_k_headers_full_v khr

1679: ,khr.currency_conversion_type currency_conversion_type
1680: ,khr.currency_conversion_date currency_conversion_date
1681: ,khr.scs_code
1682: FROM okl_products_v pdt
1683: ,okl_k_headers_full_v khr
1684: WHERE khr.id = p_contract_id
1685: AND khr.pdt_id = pdt.id;
1686:
1687: -- Get the product type

Line 1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

1689: SELECT description
1690: FROM OKL_PRODUCTS_V
1691: WHERE id = p_pdt_id;
1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

1690: FROM OKL_PRODUCTS_V
1691: WHERE id = p_pdt_id;
1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1698: l_functional_currency_code VARCHAR2(15);

Line 1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1691: WHERE id = p_pdt_id;
1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1698: l_functional_currency_code VARCHAR2(15);
1699: l_contract_currency_code VARCHAR2(15);

Line 1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1698: l_functional_currency_code VARCHAR2(15);
1699: l_contract_currency_code VARCHAR2(15);
1700: l_converted_amount NUMBER;

Line 1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1695: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1696: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1697: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1698: l_functional_currency_code VARCHAR2(15);
1699: l_contract_currency_code VARCHAR2(15);
1700: l_converted_amount NUMBER;
1701: l_Product_rec Product_csr%ROWTYPE;

Line 5722: FROM okl_k_headers khr,

5718: x_return_status OUT nocopy VARCHAR2) RETURN VARCHAR2 IS
5719: --cursor to get deal type
5720: CURSOR l_dealtyp_csr(PCleId IN NUMBER) IS
5721: SELECT khr.deal_type
5722: FROM okl_k_headers khr,
5723: okc_k_headers_b chrb,
5724: okc_k_lines_b cleb
5725: WHERE khr.id = chrb.id
5726: AND chrb.id = cleb.dnz_chr_id

Line 5729: l_deal_type okl_k_headers.deal_type%TYPE;

5725: WHERE khr.id = chrb.id
5726: AND chrb.id = cleb.dnz_chr_id
5727: AND cleb.id = PCleId;
5728:
5729: l_deal_type okl_k_headers.deal_type%TYPE;
5730: l_loan_yn VARCHAR2(1) DEFAULT 'N';
5731:
5732: BEGIN
5733: ----

Line 5883: FROM okl_k_headers_full_v khrv,

5879: khrv.currency_conversion_type,
5880: khrv.currency_conversion_rate,
5881: khrv.currency_conversion_date,
5882: khrv.start_date
5883: FROM okl_k_headers_full_v khrv,
5884: okc_k_lines_b cle
5885: WHERE khrv.id = cle.dnz_chr_id
5886: AND cle.id = PCleId;
5887:

Line 11152: okl_k_headers khr,

11148: cleb.dnz_chr_id chr_id,
11149: khr.PDT_ID,
11150: chr.START_DATE
11151: FROM okc_k_lines_b cleb,
11152: okl_k_headers khr,
11153: OKC_K_HEADERS_B chr
11154: WHERE cleb.id = pcleid
11155: and khr.id = cleb.dnz_chr_id
11156: and chr.id = khr.id;

Line 12353: okl_k_headers khr,

12349: cleb.dnz_chr_id chr_id,
12350: khr.PDT_ID,
12351: chr.START_DATE
12352: FROM okc_k_lines_b cleb,
12353: okl_k_headers khr,
12354: OKC_K_HEADERS_B chr
12355: WHERE cleb.id = pcleid
12356: and khr.id = cleb.dnz_chr_id
12357: and chr.id = khr.id;

Line 14892: okl_k_headers k

14888: (SELECT 1
14889: FROM okl_trx_quotes_b h,
14890: okl_txl_quote_lines_b l,
14891: okl_trx_contracts t,
14892: okl_k_headers k
14893: WHERE h.id = l.qte_id
14894: AND h.id = t.qte_id
14895: AND h.khr_id = k.id
14896: AND (( k.deal_type LIKE 'LEASE%' AND h.qtp_code IN