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_LEASE_TRMNT_PVT dependencies on OKL_K_LINES

Line 3370: FROM okl_k_lines_full_v

3366: -- This cursor is used to get the cost,
3367: -- residual value of an asset from the Financial Asset (TOP LINE)
3368: CURSOR l_linesfullv_csr(p_id NUMBER) IS
3369: SELECT oec, residual_value
3370: FROM okl_k_lines_full_v
3371: WHERE id = p_id;
3372:
3373: -- This cursor will return deal_type for a particular contract
3374: CURSOR l_lhrfv_csr IS

Line 6239: FROM okl_k_lines okl_line,

6235: -- Modified cursor by passing sty_id based on the purspose and
6236: -- removed reference to stream type view.
6237: CURSOR idc_accel_csr(p_khr_id IN NUMBER, p_sty_id IN NUMBER,p_kle_id IN Number) IS
6238: SELECT okl_line.fee_type fee_type
6239: FROM okl_k_lines okl_line,
6240: okc_k_lines_b okc_line,
6241: okc_line_styles_b lse,
6242: okl_streams stm
6243: WHERE okl_line.id = okc_line.id AND

Line 6421: FROM okl_k_lines okl

6417: attribute12,
6418: attribute13,
6419: attribute14,
6420: attribute15
6421: FROM okl_k_lines okl
6422: WHERE okl.id = p_kle_id;
6423: --record for storing okl_k_lines dffs and linked assets cle_id
6424: TYPE dff_rec_type IS RECORD(
6425: attribute_category okl_k_lines.attribute_category%TYPE,

Line 6423: --record for storing okl_k_lines dffs and linked assets cle_id

6419: attribute14,
6420: attribute15
6421: FROM okl_k_lines okl
6422: WHERE okl.id = p_kle_id;
6423: --record for storing okl_k_lines dffs and linked assets cle_id
6424: TYPE dff_rec_type IS RECORD(
6425: attribute_category okl_k_lines.attribute_category%TYPE,
6426: attribute1 okl_k_lines.attribute1%TYPE,
6427: attribute2 okl_k_lines.attribute2%TYPE,

Line 6425: attribute_category okl_k_lines.attribute_category%TYPE,

6421: FROM okl_k_lines okl
6422: WHERE okl.id = p_kle_id;
6423: --record for storing okl_k_lines dffs and linked assets cle_id
6424: TYPE dff_rec_type IS RECORD(
6425: attribute_category okl_k_lines.attribute_category%TYPE,
6426: attribute1 okl_k_lines.attribute1%TYPE,
6427: attribute2 okl_k_lines.attribute2%TYPE,
6428: attribute3 okl_k_lines.attribute3%TYPE,
6429: attribute4 okl_k_lines.attribute4%TYPE,

Line 6426: attribute1 okl_k_lines.attribute1%TYPE,

6422: WHERE okl.id = p_kle_id;
6423: --record for storing okl_k_lines dffs and linked assets cle_id
6424: TYPE dff_rec_type IS RECORD(
6425: attribute_category okl_k_lines.attribute_category%TYPE,
6426: attribute1 okl_k_lines.attribute1%TYPE,
6427: attribute2 okl_k_lines.attribute2%TYPE,
6428: attribute3 okl_k_lines.attribute3%TYPE,
6429: attribute4 okl_k_lines.attribute4%TYPE,
6430: attribute5 okl_k_lines.attribute5%TYPE,

Line 6427: attribute2 okl_k_lines.attribute2%TYPE,

6423: --record for storing okl_k_lines dffs and linked assets cle_id
6424: TYPE dff_rec_type IS RECORD(
6425: attribute_category okl_k_lines.attribute_category%TYPE,
6426: attribute1 okl_k_lines.attribute1%TYPE,
6427: attribute2 okl_k_lines.attribute2%TYPE,
6428: attribute3 okl_k_lines.attribute3%TYPE,
6429: attribute4 okl_k_lines.attribute4%TYPE,
6430: attribute5 okl_k_lines.attribute5%TYPE,
6431: attribute6 okl_k_lines.attribute6%TYPE,

Line 6428: attribute3 okl_k_lines.attribute3%TYPE,

6424: TYPE dff_rec_type IS RECORD(
6425: attribute_category okl_k_lines.attribute_category%TYPE,
6426: attribute1 okl_k_lines.attribute1%TYPE,
6427: attribute2 okl_k_lines.attribute2%TYPE,
6428: attribute3 okl_k_lines.attribute3%TYPE,
6429: attribute4 okl_k_lines.attribute4%TYPE,
6430: attribute5 okl_k_lines.attribute5%TYPE,
6431: attribute6 okl_k_lines.attribute6%TYPE,
6432: attribute7 okl_k_lines.attribute7%TYPE,

Line 6429: attribute4 okl_k_lines.attribute4%TYPE,

6425: attribute_category okl_k_lines.attribute_category%TYPE,
6426: attribute1 okl_k_lines.attribute1%TYPE,
6427: attribute2 okl_k_lines.attribute2%TYPE,
6428: attribute3 okl_k_lines.attribute3%TYPE,
6429: attribute4 okl_k_lines.attribute4%TYPE,
6430: attribute5 okl_k_lines.attribute5%TYPE,
6431: attribute6 okl_k_lines.attribute6%TYPE,
6432: attribute7 okl_k_lines.attribute7%TYPE,
6433: attribute8 okl_k_lines.attribute8%TYPE,

Line 6430: attribute5 okl_k_lines.attribute5%TYPE,

6426: attribute1 okl_k_lines.attribute1%TYPE,
6427: attribute2 okl_k_lines.attribute2%TYPE,
6428: attribute3 okl_k_lines.attribute3%TYPE,
6429: attribute4 okl_k_lines.attribute4%TYPE,
6430: attribute5 okl_k_lines.attribute5%TYPE,
6431: attribute6 okl_k_lines.attribute6%TYPE,
6432: attribute7 okl_k_lines.attribute7%TYPE,
6433: attribute8 okl_k_lines.attribute8%TYPE,
6434: attribute9 okl_k_lines.attribute9%TYPE,

Line 6431: attribute6 okl_k_lines.attribute6%TYPE,

6427: attribute2 okl_k_lines.attribute2%TYPE,
6428: attribute3 okl_k_lines.attribute3%TYPE,
6429: attribute4 okl_k_lines.attribute4%TYPE,
6430: attribute5 okl_k_lines.attribute5%TYPE,
6431: attribute6 okl_k_lines.attribute6%TYPE,
6432: attribute7 okl_k_lines.attribute7%TYPE,
6433: attribute8 okl_k_lines.attribute8%TYPE,
6434: attribute9 okl_k_lines.attribute9%TYPE,
6435: attribute10 okl_k_lines.attribute10%TYPE,

Line 6432: attribute7 okl_k_lines.attribute7%TYPE,

6428: attribute3 okl_k_lines.attribute3%TYPE,
6429: attribute4 okl_k_lines.attribute4%TYPE,
6430: attribute5 okl_k_lines.attribute5%TYPE,
6431: attribute6 okl_k_lines.attribute6%TYPE,
6432: attribute7 okl_k_lines.attribute7%TYPE,
6433: attribute8 okl_k_lines.attribute8%TYPE,
6434: attribute9 okl_k_lines.attribute9%TYPE,
6435: attribute10 okl_k_lines.attribute10%TYPE,
6436: attribute11 okl_k_lines.attribute11%TYPE,

Line 6433: attribute8 okl_k_lines.attribute8%TYPE,

6429: attribute4 okl_k_lines.attribute4%TYPE,
6430: attribute5 okl_k_lines.attribute5%TYPE,
6431: attribute6 okl_k_lines.attribute6%TYPE,
6432: attribute7 okl_k_lines.attribute7%TYPE,
6433: attribute8 okl_k_lines.attribute8%TYPE,
6434: attribute9 okl_k_lines.attribute9%TYPE,
6435: attribute10 okl_k_lines.attribute10%TYPE,
6436: attribute11 okl_k_lines.attribute11%TYPE,
6437: attribute12 okl_k_lines.attribute12%TYPE,

Line 6434: attribute9 okl_k_lines.attribute9%TYPE,

6430: attribute5 okl_k_lines.attribute5%TYPE,
6431: attribute6 okl_k_lines.attribute6%TYPE,
6432: attribute7 okl_k_lines.attribute7%TYPE,
6433: attribute8 okl_k_lines.attribute8%TYPE,
6434: attribute9 okl_k_lines.attribute9%TYPE,
6435: attribute10 okl_k_lines.attribute10%TYPE,
6436: attribute11 okl_k_lines.attribute11%TYPE,
6437: attribute12 okl_k_lines.attribute12%TYPE,
6438: attribute13 okl_k_lines.attribute13%TYPE,

Line 6435: attribute10 okl_k_lines.attribute10%TYPE,

6431: attribute6 okl_k_lines.attribute6%TYPE,
6432: attribute7 okl_k_lines.attribute7%TYPE,
6433: attribute8 okl_k_lines.attribute8%TYPE,
6434: attribute9 okl_k_lines.attribute9%TYPE,
6435: attribute10 okl_k_lines.attribute10%TYPE,
6436: attribute11 okl_k_lines.attribute11%TYPE,
6437: attribute12 okl_k_lines.attribute12%TYPE,
6438: attribute13 okl_k_lines.attribute13%TYPE,
6439: attribute14 okl_k_lines.attribute14%TYPE,

Line 6436: attribute11 okl_k_lines.attribute11%TYPE,

6432: attribute7 okl_k_lines.attribute7%TYPE,
6433: attribute8 okl_k_lines.attribute8%TYPE,
6434: attribute9 okl_k_lines.attribute9%TYPE,
6435: attribute10 okl_k_lines.attribute10%TYPE,
6436: attribute11 okl_k_lines.attribute11%TYPE,
6437: attribute12 okl_k_lines.attribute12%TYPE,
6438: attribute13 okl_k_lines.attribute13%TYPE,
6439: attribute14 okl_k_lines.attribute14%TYPE,
6440: attribute15 okl_k_lines.attribute15%TYPE);

Line 6437: attribute12 okl_k_lines.attribute12%TYPE,

6433: attribute8 okl_k_lines.attribute8%TYPE,
6434: attribute9 okl_k_lines.attribute9%TYPE,
6435: attribute10 okl_k_lines.attribute10%TYPE,
6436: attribute11 okl_k_lines.attribute11%TYPE,
6437: attribute12 okl_k_lines.attribute12%TYPE,
6438: attribute13 okl_k_lines.attribute13%TYPE,
6439: attribute14 okl_k_lines.attribute14%TYPE,
6440: attribute15 okl_k_lines.attribute15%TYPE);
6441: txl_contracts_dff_rec dff_rec_type;

Line 6438: attribute13 okl_k_lines.attribute13%TYPE,

6434: attribute9 okl_k_lines.attribute9%TYPE,
6435: attribute10 okl_k_lines.attribute10%TYPE,
6436: attribute11 okl_k_lines.attribute11%TYPE,
6437: attribute12 okl_k_lines.attribute12%TYPE,
6438: attribute13 okl_k_lines.attribute13%TYPE,
6439: attribute14 okl_k_lines.attribute14%TYPE,
6440: attribute15 okl_k_lines.attribute15%TYPE);
6441: txl_contracts_dff_rec dff_rec_type;
6442: --product name and tax owner

Line 6439: attribute14 okl_k_lines.attribute14%TYPE,

6435: attribute10 okl_k_lines.attribute10%TYPE,
6436: attribute11 okl_k_lines.attribute11%TYPE,
6437: attribute12 okl_k_lines.attribute12%TYPE,
6438: attribute13 okl_k_lines.attribute13%TYPE,
6439: attribute14 okl_k_lines.attribute14%TYPE,
6440: attribute15 okl_k_lines.attribute15%TYPE);
6441: txl_contracts_dff_rec dff_rec_type;
6442: --product name and tax owner
6443: CURSOR product_name_csr(p_pdt_id IN NUMBER) IS

Line 6440: attribute15 okl_k_lines.attribute15%TYPE);

6436: attribute11 okl_k_lines.attribute11%TYPE,
6437: attribute12 okl_k_lines.attribute12%TYPE,
6438: attribute13 okl_k_lines.attribute13%TYPE,
6439: attribute14 okl_k_lines.attribute14%TYPE,
6440: attribute15 okl_k_lines.attribute15%TYPE);
6441: txl_contracts_dff_rec dff_rec_type;
6442: --product name and tax owner
6443: CURSOR product_name_csr(p_pdt_id IN NUMBER) IS
6444: SELECT NAME,

Line 7814: p_kle_id IN OKL_K_LINES.ID%TYPE,

7810:
7811: PROCEDURE Create_Repo_asset_2(
7812: p_init_msg_list IN VARCHAR2,
7813: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
7814: p_kle_id IN OKL_K_LINES.ID%TYPE,
7815: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
7816: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
7817: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
7818: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,

Line 7842: okl_k_lines fa_kle,

7838: FROM okc_k_lines_b cle,
7839: okc_k_items cim,
7840: okc_line_styles_b lse,
7841: okc_statuses_b sts,
7842: okl_k_lines fa_kle,
7843: okc_k_lines_b fa_cle,
7844: okc_line_styles_b fa_lse
7845: WHERE cle.dnz_chr_id = p_chr_id
7846: AND cle.cle_id = p_cle_id

Line 8300: p_kle_id IN OKL_K_LINES.ID%TYPE,

8296: --Call to SLA Populate Sources
8297: PROCEDURE Populate_Sources(p_api_version IN NUMBER,
8298: p_init_msg_list IN VARCHAR2,
8299: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8300: p_kle_id IN OKL_K_LINES.ID%TYPE,
8301: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8302: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8303: p_tal_id IN NUMBER,
8304: p_line_type IN VARCHAR2,

Line 8410: p_kle_id IN OKL_K_LINES.ID%TYPE,

8406:
8407: PROCEDURE Create_Repo_asset(
8408: p_init_msg_list IN VARCHAR2,
8409: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8410: p_kle_id IN OKL_K_LINES.ID%TYPE,
8411: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8412: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8413: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8414: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,

Line 8438: okl_k_lines fa_kle,

8434: FROM okc_k_lines_b cle,
8435: okc_k_items cim,
8436: okc_line_styles_b lse,
8437: okc_statuses_b sts,
8438: okl_k_lines fa_kle,
8439: okc_k_lines_b fa_cle,
8440: okc_line_styles_b fa_lse
8441: WHERE cle.dnz_chr_id = p_chr_id
8442: AND cle.cle_id = p_cle_id