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 1180: FROM OKL_K_HEADERS A,

1176: -- MGAAP start 7263041
1177: CURSOR check_csr(p_chr_id NUMBER) IS
1178: SELECT A.MULTI_GAAP_YN,
1179: B.REPORTING_PDT_ID
1180: FROM OKL_K_HEADERS A,
1181: OKL_PRODUCTS B
1182: WHERE A.ID = p_chr_id
1183: AND A.PDT_ID = B.ID;
1184:

Line 1185: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

1181: OKL_PRODUCTS B
1182: WHERE A.ID = p_chr_id
1183: AND A.PDT_ID = B.ID;
1184:
1185: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
1186: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
1187: -- MGAAP start 7263041
1188:
1189: BEGIN

Line 1655: ,okl_k_headers_full_v khr

1651: ,khr.currency_conversion_type currency_conversion_type
1652: ,khr.currency_conversion_date currency_conversion_date
1653: ,khr.scs_code
1654: FROM okl_products_v pdt
1655: ,okl_k_headers_full_v khr
1656: WHERE khr.id = p_contract_id
1657: AND khr.pdt_id = pdt.id;
1658:
1659: -- Get the product type

Line 1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

1661: SELECT description
1662: FROM OKL_PRODUCTS_V
1663: WHERE id = p_pdt_id;
1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

1662: FROM OKL_PRODUCTS_V
1663: WHERE id = p_pdt_id;
1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1670: l_functional_currency_code VARCHAR2(15);

Line 1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1663: WHERE id = p_pdt_id;
1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1670: l_functional_currency_code VARCHAR2(15);
1671: l_contract_currency_code VARCHAR2(15);

Line 1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1664:
1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1670: l_functional_currency_code VARCHAR2(15);
1671: l_contract_currency_code VARCHAR2(15);
1672: l_converted_amount NUMBER;

Line 1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1665: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1666: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1667: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1668: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1669: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1670: l_functional_currency_code VARCHAR2(15);
1671: l_contract_currency_code VARCHAR2(15);
1672: l_converted_amount NUMBER;
1673: l_Product_rec Product_csr%ROWTYPE;

Line 5694: FROM okl_k_headers khr,

5690: x_return_status OUT nocopy VARCHAR2) RETURN VARCHAR2 IS
5691: --cursor to get deal type
5692: CURSOR l_dealtyp_csr(PCleId IN NUMBER) IS
5693: SELECT khr.deal_type
5694: FROM okl_k_headers khr,
5695: okc_k_headers_b chrb,
5696: okc_k_lines_b cleb
5697: WHERE khr.id = chrb.id
5698: AND chrb.id = cleb.dnz_chr_id

Line 5701: l_deal_type okl_k_headers.deal_type%TYPE;

5697: WHERE khr.id = chrb.id
5698: AND chrb.id = cleb.dnz_chr_id
5699: AND cleb.id = PCleId;
5700:
5701: l_deal_type okl_k_headers.deal_type%TYPE;
5702: l_loan_yn VARCHAR2(1) DEFAULT 'N';
5703:
5704: BEGIN
5705: ----

Line 5855: FROM okl_k_headers_full_v khrv,

5851: khrv.currency_conversion_type,
5852: khrv.currency_conversion_rate,
5853: khrv.currency_conversion_date,
5854: khrv.start_date
5855: FROM okl_k_headers_full_v khrv,
5856: okc_k_lines_b cle
5857: WHERE khrv.id = cle.dnz_chr_id
5858: AND cle.id = PCleId;
5859:

Line 11099: okl_k_headers khr,

11095: cleb.dnz_chr_id chr_id,
11096: khr.PDT_ID,
11097: chr.START_DATE
11098: FROM okc_k_lines_b cleb,
11099: okl_k_headers khr,
11100: OKC_K_HEADERS_B chr
11101: WHERE cleb.id = pcleid
11102: and khr.id = cleb.dnz_chr_id
11103: and chr.id = khr.id;

Line 12300: okl_k_headers khr,

12296: cleb.dnz_chr_id chr_id,
12297: khr.PDT_ID,
12298: chr.START_DATE
12299: FROM okc_k_lines_b cleb,
12300: okl_k_headers khr,
12301: OKC_K_HEADERS_B chr
12302: WHERE cleb.id = pcleid
12303: and khr.id = cleb.dnz_chr_id
12304: and chr.id = khr.id;

Line 14839: okl_k_headers k

14835: (SELECT 1
14836: FROM okl_trx_quotes_b h,
14837: okl_txl_quote_lines_b l,
14838: okl_trx_contracts t,
14839: okl_k_headers k
14840: WHERE h.id = l.qte_id
14841: AND h.id = t.qte_id
14842: AND h.khr_id = k.id
14843: AND (( k.deal_type LIKE 'LEASE%' AND h.qtp_code IN