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 OKC_LINE_STYLES_B

Line 576: FROM okc_k_lines_v a , okc_line_styles_b b

572:
573: -- get the active financial asset lines for the contract
574: CURSOR l_okcklines_csr(cp_khr_id IN NUMBER, cp_sts_code IN VARCHAR2) IS
575: SELECT a.id, a.name
576: FROM okc_k_lines_v a , okc_line_styles_b b
577: WHERE a.chr_id = cp_khr_id
578: AND a.lse_id = b.id
579: AND b.lty_code = 'FREE_FORM1'
580: AND a.sts_code = cp_sts_code;

Line 6241: okc_line_styles_b lse,

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
6244: okc_line.lse_id = lse.id AND lse.lty_code = 'FEE' AND
6245: okc_line.chr_id = p_khr_id AND

Line 6257: okc_line_styles_b lse,

6253: -- ansethur for bug#6156337 08-aug-07 start
6254: CURSOR primary_sty_id_csr (p_khr_id IN NUMBER) IS
6255: SELECT sty.id Primary_sty_id, sty.code,okc_line.id kle_id
6256: FROM okc_k_lines_b okc_line,
6257: okc_line_styles_b lse,
6258: okc_k_items item,
6259: okl_strm_type_b sty
6260: WHERE okc_line.dnz_chr_id = p_khr_id
6261: AND okc_line.lse_id = lse.id

Line 7840: okc_line_styles_b lse,

7836: cim.number_of_items,
7837: fa_kle.year_of_manufacture
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

Line 7844: okc_line_styles_b fa_lse

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
7847: AND cle.lse_id = lse.id
7848: AND lse.lty_code = p_lty_code

Line 7899: OKC_LINE_STYLES_B LSE

7895: CURSOR c_cim_asset_id(p_cle_id IN NUMBER) IS
7896: SELECT ITM.ID
7897: FROM OKC_K_ITEMS ITM,
7898: OKC_K_LINES_B CLE,
7899: OKC_LINE_STYLES_B LSE
7900: WHERE ITM.CLE_ID = cle.ID
7901: AND CLE.CLE_ID = p_cle_id
7902: AND CLE.LSE_ID = LSE.ID
7903: AND LSE.LTY_CODE = 'FIXED_ASSET';

Line 8436: okc_line_styles_b lse,

8432: cim.number_of_items,
8433: fa_kle.year_of_manufacture
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

Line 8440: okc_line_styles_b fa_lse

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
8443: AND cle.lse_id = lse.id
8444: AND lse.lty_code = p_lty_code

Line 8495: OKC_LINE_STYLES_B LSE

8491: CURSOR c_cim_asset_id(p_cle_id IN NUMBER) IS
8492: SELECT ITM.ID
8493: FROM OKC_K_ITEMS ITM,
8494: OKC_K_LINES_B CLE,
8495: OKC_LINE_STYLES_B LSE
8496: WHERE ITM.CLE_ID = cle.ID
8497: AND CLE.CLE_ID = p_cle_id
8498: AND CLE.LSE_ID = LSE.ID
8499: AND LSE.LTY_CODE = 'FIXED_ASSET';