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 3486: FROM okl_k_lines_full_v

3482: -- This cursor is used to get the cost,
3483: -- residual value of an asset from the Financial Asset (TOP LINE)
3484: CURSOR l_linesfullv_csr(p_id NUMBER) IS
3485: SELECT oec, residual_value
3486: FROM okl_k_lines_full_v
3487: WHERE id = p_id;
3488:
3489: -- This cursor will return deal_type for a particular contract
3490: CURSOR l_lhrfv_csr IS

Line 6405: FROM okl_k_lines okl_line,

6401: -- Modified cursor by passing sty_id based on the purspose and
6402: -- removed reference to stream type view.
6403: CURSOR idc_accel_csr(p_khr_id IN NUMBER, p_sty_id IN NUMBER,p_kle_id IN Number) IS
6404: SELECT okl_line.fee_type fee_type
6405: FROM okl_k_lines okl_line,
6406: okc_k_lines_b okc_line,
6407: okc_line_styles_b lse,
6408: okl_streams stm
6409: WHERE okl_line.id = okc_line.id AND

Line 6587: FROM okl_k_lines okl

6583: attribute12,
6584: attribute13,
6585: attribute14,
6586: attribute15
6587: FROM okl_k_lines okl
6588: WHERE okl.id = p_kle_id;
6589: --record for storing okl_k_lines dffs and linked assets cle_id
6590: TYPE dff_rec_type IS RECORD(
6591: attribute_category okl_k_lines.attribute_category%TYPE,

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

6585: attribute14,
6586: attribute15
6587: FROM okl_k_lines okl
6588: WHERE okl.id = p_kle_id;
6589: --record for storing okl_k_lines dffs and linked assets cle_id
6590: TYPE dff_rec_type IS RECORD(
6591: attribute_category okl_k_lines.attribute_category%TYPE,
6592: attribute1 okl_k_lines.attribute1%TYPE,
6593: attribute2 okl_k_lines.attribute2%TYPE,

Line 6591: attribute_category okl_k_lines.attribute_category%TYPE,

6587: FROM okl_k_lines okl
6588: WHERE okl.id = p_kle_id;
6589: --record for storing okl_k_lines dffs and linked assets cle_id
6590: TYPE dff_rec_type IS RECORD(
6591: attribute_category okl_k_lines.attribute_category%TYPE,
6592: attribute1 okl_k_lines.attribute1%TYPE,
6593: attribute2 okl_k_lines.attribute2%TYPE,
6594: attribute3 okl_k_lines.attribute3%TYPE,
6595: attribute4 okl_k_lines.attribute4%TYPE,

Line 6592: attribute1 okl_k_lines.attribute1%TYPE,

6588: WHERE okl.id = p_kle_id;
6589: --record for storing okl_k_lines dffs and linked assets cle_id
6590: TYPE dff_rec_type IS RECORD(
6591: attribute_category okl_k_lines.attribute_category%TYPE,
6592: attribute1 okl_k_lines.attribute1%TYPE,
6593: attribute2 okl_k_lines.attribute2%TYPE,
6594: attribute3 okl_k_lines.attribute3%TYPE,
6595: attribute4 okl_k_lines.attribute4%TYPE,
6596: attribute5 okl_k_lines.attribute5%TYPE,

Line 6593: attribute2 okl_k_lines.attribute2%TYPE,

6589: --record for storing okl_k_lines dffs and linked assets cle_id
6590: TYPE dff_rec_type IS RECORD(
6591: attribute_category okl_k_lines.attribute_category%TYPE,
6592: attribute1 okl_k_lines.attribute1%TYPE,
6593: attribute2 okl_k_lines.attribute2%TYPE,
6594: attribute3 okl_k_lines.attribute3%TYPE,
6595: attribute4 okl_k_lines.attribute4%TYPE,
6596: attribute5 okl_k_lines.attribute5%TYPE,
6597: attribute6 okl_k_lines.attribute6%TYPE,

Line 6594: attribute3 okl_k_lines.attribute3%TYPE,

6590: TYPE dff_rec_type IS RECORD(
6591: attribute_category okl_k_lines.attribute_category%TYPE,
6592: attribute1 okl_k_lines.attribute1%TYPE,
6593: attribute2 okl_k_lines.attribute2%TYPE,
6594: attribute3 okl_k_lines.attribute3%TYPE,
6595: attribute4 okl_k_lines.attribute4%TYPE,
6596: attribute5 okl_k_lines.attribute5%TYPE,
6597: attribute6 okl_k_lines.attribute6%TYPE,
6598: attribute7 okl_k_lines.attribute7%TYPE,

Line 6595: attribute4 okl_k_lines.attribute4%TYPE,

6591: attribute_category okl_k_lines.attribute_category%TYPE,
6592: attribute1 okl_k_lines.attribute1%TYPE,
6593: attribute2 okl_k_lines.attribute2%TYPE,
6594: attribute3 okl_k_lines.attribute3%TYPE,
6595: attribute4 okl_k_lines.attribute4%TYPE,
6596: attribute5 okl_k_lines.attribute5%TYPE,
6597: attribute6 okl_k_lines.attribute6%TYPE,
6598: attribute7 okl_k_lines.attribute7%TYPE,
6599: attribute8 okl_k_lines.attribute8%TYPE,

Line 6596: attribute5 okl_k_lines.attribute5%TYPE,

6592: attribute1 okl_k_lines.attribute1%TYPE,
6593: attribute2 okl_k_lines.attribute2%TYPE,
6594: attribute3 okl_k_lines.attribute3%TYPE,
6595: attribute4 okl_k_lines.attribute4%TYPE,
6596: attribute5 okl_k_lines.attribute5%TYPE,
6597: attribute6 okl_k_lines.attribute6%TYPE,
6598: attribute7 okl_k_lines.attribute7%TYPE,
6599: attribute8 okl_k_lines.attribute8%TYPE,
6600: attribute9 okl_k_lines.attribute9%TYPE,

Line 6597: attribute6 okl_k_lines.attribute6%TYPE,

6593: attribute2 okl_k_lines.attribute2%TYPE,
6594: attribute3 okl_k_lines.attribute3%TYPE,
6595: attribute4 okl_k_lines.attribute4%TYPE,
6596: attribute5 okl_k_lines.attribute5%TYPE,
6597: attribute6 okl_k_lines.attribute6%TYPE,
6598: attribute7 okl_k_lines.attribute7%TYPE,
6599: attribute8 okl_k_lines.attribute8%TYPE,
6600: attribute9 okl_k_lines.attribute9%TYPE,
6601: attribute10 okl_k_lines.attribute10%TYPE,

Line 6598: attribute7 okl_k_lines.attribute7%TYPE,

6594: attribute3 okl_k_lines.attribute3%TYPE,
6595: attribute4 okl_k_lines.attribute4%TYPE,
6596: attribute5 okl_k_lines.attribute5%TYPE,
6597: attribute6 okl_k_lines.attribute6%TYPE,
6598: attribute7 okl_k_lines.attribute7%TYPE,
6599: attribute8 okl_k_lines.attribute8%TYPE,
6600: attribute9 okl_k_lines.attribute9%TYPE,
6601: attribute10 okl_k_lines.attribute10%TYPE,
6602: attribute11 okl_k_lines.attribute11%TYPE,

Line 6599: attribute8 okl_k_lines.attribute8%TYPE,

6595: attribute4 okl_k_lines.attribute4%TYPE,
6596: attribute5 okl_k_lines.attribute5%TYPE,
6597: attribute6 okl_k_lines.attribute6%TYPE,
6598: attribute7 okl_k_lines.attribute7%TYPE,
6599: attribute8 okl_k_lines.attribute8%TYPE,
6600: attribute9 okl_k_lines.attribute9%TYPE,
6601: attribute10 okl_k_lines.attribute10%TYPE,
6602: attribute11 okl_k_lines.attribute11%TYPE,
6603: attribute12 okl_k_lines.attribute12%TYPE,

Line 6600: attribute9 okl_k_lines.attribute9%TYPE,

6596: attribute5 okl_k_lines.attribute5%TYPE,
6597: attribute6 okl_k_lines.attribute6%TYPE,
6598: attribute7 okl_k_lines.attribute7%TYPE,
6599: attribute8 okl_k_lines.attribute8%TYPE,
6600: attribute9 okl_k_lines.attribute9%TYPE,
6601: attribute10 okl_k_lines.attribute10%TYPE,
6602: attribute11 okl_k_lines.attribute11%TYPE,
6603: attribute12 okl_k_lines.attribute12%TYPE,
6604: attribute13 okl_k_lines.attribute13%TYPE,

Line 6601: attribute10 okl_k_lines.attribute10%TYPE,

6597: attribute6 okl_k_lines.attribute6%TYPE,
6598: attribute7 okl_k_lines.attribute7%TYPE,
6599: attribute8 okl_k_lines.attribute8%TYPE,
6600: attribute9 okl_k_lines.attribute9%TYPE,
6601: attribute10 okl_k_lines.attribute10%TYPE,
6602: attribute11 okl_k_lines.attribute11%TYPE,
6603: attribute12 okl_k_lines.attribute12%TYPE,
6604: attribute13 okl_k_lines.attribute13%TYPE,
6605: attribute14 okl_k_lines.attribute14%TYPE,

Line 6602: attribute11 okl_k_lines.attribute11%TYPE,

6598: attribute7 okl_k_lines.attribute7%TYPE,
6599: attribute8 okl_k_lines.attribute8%TYPE,
6600: attribute9 okl_k_lines.attribute9%TYPE,
6601: attribute10 okl_k_lines.attribute10%TYPE,
6602: attribute11 okl_k_lines.attribute11%TYPE,
6603: attribute12 okl_k_lines.attribute12%TYPE,
6604: attribute13 okl_k_lines.attribute13%TYPE,
6605: attribute14 okl_k_lines.attribute14%TYPE,
6606: attribute15 okl_k_lines.attribute15%TYPE);

Line 6603: attribute12 okl_k_lines.attribute12%TYPE,

6599: attribute8 okl_k_lines.attribute8%TYPE,
6600: attribute9 okl_k_lines.attribute9%TYPE,
6601: attribute10 okl_k_lines.attribute10%TYPE,
6602: attribute11 okl_k_lines.attribute11%TYPE,
6603: attribute12 okl_k_lines.attribute12%TYPE,
6604: attribute13 okl_k_lines.attribute13%TYPE,
6605: attribute14 okl_k_lines.attribute14%TYPE,
6606: attribute15 okl_k_lines.attribute15%TYPE);
6607: txl_contracts_dff_rec dff_rec_type;

Line 6604: attribute13 okl_k_lines.attribute13%TYPE,

6600: attribute9 okl_k_lines.attribute9%TYPE,
6601: attribute10 okl_k_lines.attribute10%TYPE,
6602: attribute11 okl_k_lines.attribute11%TYPE,
6603: attribute12 okl_k_lines.attribute12%TYPE,
6604: attribute13 okl_k_lines.attribute13%TYPE,
6605: attribute14 okl_k_lines.attribute14%TYPE,
6606: attribute15 okl_k_lines.attribute15%TYPE);
6607: txl_contracts_dff_rec dff_rec_type;
6608: --product name and tax owner

Line 6605: attribute14 okl_k_lines.attribute14%TYPE,

6601: attribute10 okl_k_lines.attribute10%TYPE,
6602: attribute11 okl_k_lines.attribute11%TYPE,
6603: attribute12 okl_k_lines.attribute12%TYPE,
6604: attribute13 okl_k_lines.attribute13%TYPE,
6605: attribute14 okl_k_lines.attribute14%TYPE,
6606: attribute15 okl_k_lines.attribute15%TYPE);
6607: txl_contracts_dff_rec dff_rec_type;
6608: --product name and tax owner
6609: CURSOR product_name_csr(p_pdt_id IN NUMBER) IS

Line 6606: attribute15 okl_k_lines.attribute15%TYPE);

6602: attribute11 okl_k_lines.attribute11%TYPE,
6603: attribute12 okl_k_lines.attribute12%TYPE,
6604: attribute13 okl_k_lines.attribute13%TYPE,
6605: attribute14 okl_k_lines.attribute14%TYPE,
6606: attribute15 okl_k_lines.attribute15%TYPE);
6607: txl_contracts_dff_rec dff_rec_type;
6608: --product name and tax owner
6609: CURSOR product_name_csr(p_pdt_id IN NUMBER) IS
6610: SELECT NAME,

Line 8013: p_kle_id IN OKL_K_LINES.ID%TYPE,

8009:
8010: PROCEDURE Create_Repo_asset_2(
8011: p_init_msg_list IN VARCHAR2,
8012: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8013: p_kle_id IN OKL_K_LINES.ID%TYPE,
8014: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8015: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8016: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8017: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,

Line 8041: okl_k_lines fa_kle,

8037: FROM okc_k_lines_b cle,
8038: okc_k_items cim,
8039: okc_line_styles_b lse,
8040: okc_statuses_b sts,
8041: okl_k_lines fa_kle,
8042: okc_k_lines_b fa_cle,
8043: okc_line_styles_b fa_lse
8044: WHERE cle.dnz_chr_id = p_chr_id
8045: AND cle.cle_id = p_cle_id

Line 8499: p_kle_id IN OKL_K_LINES.ID%TYPE,

8495: --Call to SLA Populate Sources
8496: PROCEDURE Populate_Sources(p_api_version IN NUMBER,
8497: p_init_msg_list IN VARCHAR2,
8498: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8499: p_kle_id IN OKL_K_LINES.ID%TYPE,
8500: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8501: p_tas_id IN OKL_TRX_ASSETS.ID%TYPE,
8502: p_tal_id IN NUMBER,
8503: p_line_type IN VARCHAR2,

Line 8609: p_kle_id IN OKL_K_LINES.ID%TYPE,

8605:
8606: PROCEDURE Create_Repo_asset(
8607: p_init_msg_list IN VARCHAR2,
8608: p_khr_id IN OKC_K_HEADERS_B.ID%TYPE,
8609: p_kle_id IN OKL_K_LINES.ID%TYPE,
8610: p_corporate_book IN OKL_SYSTEM_PARAMS_ALL.CORPORATE_BOOK%TYPE,
8611: p_tax_book_1 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%TYPE,
8612: p_tax_book_2 IN OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%TYPE,
8613: p_rep_book IN OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE,

Line 8637: okl_k_lines fa_kle,

8633: FROM okc_k_lines_b cle,
8634: okc_k_items cim,
8635: okc_line_styles_b lse,
8636: okc_statuses_b sts,
8637: okl_k_lines fa_kle,
8638: okc_k_lines_b fa_cle,
8639: okc_line_styles_b fa_lse
8640: WHERE cle.dnz_chr_id = p_chr_id
8641: AND cle.cle_id = p_cle_id