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_CNTRCT_LN_TRMNT_PVT dependencies on OKC_K_LINES_V

Line 1304: okc_k_lines_v kle

1300: tql.ID tql_id,
1301: tql.quote_quantity quote_quantity,
1302: tql.split_kle_name split_kle_name -- RMUNJULU 2757312
1303: FROM okl_txl_quote_lines_v tql,
1304: okc_k_lines_v kle
1305: WHERE tql.qte_id = p_qte_id
1306: AND tql.qlt_code = 'AMCFIA'
1307: AND tql.kle_id = kle.ID;
1308:

Line 1436: FROM okc_k_lines_v kle

1432: p_kle_id IN NUMBER
1433: )
1434: IS
1435: SELECT kle.sts_code sts_code
1436: FROM okc_k_lines_v kle
1437: WHERE kle.ID = p_kle_id;
1438:
1439: i NUMBER := 1;
1440: l_k_sts VARCHAR2 (30);

Line 2355: FROM okc_k_lines_v kle

2351: p_kle_id IN NUMBER
2352: )
2353: IS
2354: SELECT kle.NAME NAME
2355: FROM okc_k_lines_v kle
2356: WHERE kle.ID = p_kle_id;
2357:
2358: -- RMUNJULU 2757312 added
2359: -- Get the ENTERED split trn

Line 2370: okc_k_lines_v kle_fin,

2366: SELECT 'N',
2367: txl.ID
2368: FROM okl_txl_assets_b txl,
2369: okl_trx_assets trx,
2370: okc_k_lines_v kle_fin,
2371: okc_k_lines_v kle_fix,
2372: okc_line_styles_b lty_fin,
2373: okc_line_styles_b lty_fix
2374: WHERE txl.tal_type = 'ALI'

Line 2371: okc_k_lines_v kle_fix,

2367: txl.ID
2368: FROM okl_txl_assets_b txl,
2369: okl_trx_assets trx,
2370: okc_k_lines_v kle_fin,
2371: okc_k_lines_v kle_fix,
2372: okc_line_styles_b lty_fin,
2373: okc_line_styles_b lty_fix
2374: WHERE txl.tal_type = 'ALI'
2375: AND trx.tsu_code = 'ENTERED'

Line 7984: okc_k_lines_v cle,

7980: SELECT cle.ID ID,
7981: cle.NAME NAME,
7982: kle.residual_value residual_value
7983: FROM okl_k_lines_v kle,
7984: okc_k_lines_v cle,
7985: okc_k_headers_v khr
7986: WHERE cle.chr_id = p_khr_id
7987: AND cle.chr_id = khr.ID
7988: AND cle.sts_code = khr.sts_code

Line 9333: p_dnz_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,

9329: -- which are of the same status as header
9330: --
9331: -- End of Commnets
9332: PROCEDURE validate_chr_cle_id (
9333: p_dnz_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,
9334: p_top_line_id IN okc_k_lines_v.ID%TYPE,
9335: x_return_status OUT NOCOPY VARCHAR2
9336: )
9337: IS

Line 9334: p_top_line_id IN okc_k_lines_v.ID%TYPE,

9330: --
9331: -- End of Commnets
9332: PROCEDURE validate_chr_cle_id (
9333: p_dnz_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,
9334: p_top_line_id IN okc_k_lines_v.ID%TYPE,
9335: x_return_status OUT NOCOPY VARCHAR2
9336: )
9337: IS
9338: ln_dummy NUMBER := 0;

Line 9352: p_dnz_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,

9348: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
9349: -- RMUNJULU 16-DEC-02 Bug # 2484327, get lines which are of the same status as header
9350: -- Cursor to validate the contract and lines to see if they are booked or not
9351: CURSOR l_k_lines_validate_csr (
9352: p_dnz_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,
9353: p_top_line_id IN okc_k_lines_v.ID%TYPE
9354: )
9355: IS
9356: SELECT 1

Line 9353: p_top_line_id IN okc_k_lines_v.ID%TYPE

9349: -- RMUNJULU 16-DEC-02 Bug # 2484327, get lines which are of the same status as header
9350: -- Cursor to validate the contract and lines to see if they are booked or not
9351: CURSOR l_k_lines_validate_csr (
9352: p_dnz_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,
9353: p_top_line_id IN okc_k_lines_v.ID%TYPE
9354: )
9355: IS
9356: SELECT 1
9357: FROM DUAL

Line 9362: okc_k_lines_v cle,

9358: WHERE EXISTS (
9359: SELECT 1
9360: FROM okc_subclass_top_line stl,
9361: okc_line_styles_v lse,
9362: okc_k_lines_v cle,
9363: okc_k_headers_v khr
9364: WHERE cle.ID = p_top_line_id
9365: AND cle.dnz_chr_id = p_dnz_chr_id
9366: AND cle.cle_id IS NULL

Line 11219: p_cle_id IN okc_k_lines_v.ID%TYPE

11215: -- RMUNJULU Bug # 2484327 changed parameters to IN
11216: -- We need to make sure that there are not Orphaned TOP lines of Fee,
11217: -- Sold Service and Usage Based Billing Lines
11218: CURSOR l_scan_sls_csr (
11219: p_cle_id IN okc_k_lines_v.ID%TYPE
11220: )
11221: IS
11222: SELECT kle.sts_code sts_code
11223: FROM okc_k_lines_b kle

Line 11255: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,

11251: -- RMUNJULU Bug # 2484327 changed parameters to IN
11252: -- We need to get the summed up amount for Sub lines of Fee and
11253: -- Sold Service Lines Excluding the terminated Lines
11254: CURSOR l_new_sls_amt_csr (
11255: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,
11256: p_sts_code IN okc_k_headers_b.sts_code%TYPE
11257: )
11258: IS
11259: SELECT SUM (kle.capital_amount) amount,

Line 11276: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE

11272: -- RMUNJULU Bug # 2484327 changed parameters to IN
11273: -- We need to get the summed up amount for Sub lines of Fee and
11274: -- Sold Service Lines, Including the terminated Lines
11275: CURSOR l_old_sls_amt_csr (
11276: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE
11277: )
11278: IS
11279: SELECT SUM (kle.capital_amount) amount,
11280: cle.cle_id cle_id

Line 11294: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,

11290:
11291: -- RMUNJULU Bug # 2484327 changed parameters to IN
11292: -- We need to get the Payment Info for Fee and Sold Service lines
11293: CURSOR l_sls_rule_pymnt_csr (
11294: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,
11295: p_cle_id IN okc_k_lines_v.ID%TYPE,
11296: p_sts_code IN okc_k_headers_b.sts_code%TYPE
11297: )
11298: IS

Line 11295: p_cle_id IN okc_k_lines_v.ID%TYPE,

11291: -- RMUNJULU Bug # 2484327 changed parameters to IN
11292: -- We need to get the Payment Info for Fee and Sold Service lines
11293: CURSOR l_sls_rule_pymnt_csr (
11294: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,
11295: p_cle_id IN okc_k_lines_v.ID%TYPE,
11296: p_sts_code IN okc_k_headers_b.sts_code%TYPE
11297: )
11298: IS
11299: SELECT rl.ID ID,

Line 11303: okc_k_lines_v cle,

11299: SELECT rl.ID ID,
11300: rl.rule_information6 payment_amount
11301: FROM okc_rule_groups_b rg,
11302: okc_rules_b rl,
11303: okc_k_lines_v cle,
11304: okc_line_styles_b lse
11305: WHERE cle.dnz_chr_id = p_chr_id
11306: AND cle.ID = p_cle_id
11307: AND cle.lse_id = lse.ID

Line 11321: FROM okc_k_lines_v cle_sl,

11317: 'LASLL'
11318: -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION
11319: AND EXISTS (
11320: SELECT '1'
11321: FROM okc_k_lines_v cle_sl,
11322: okc_line_styles_b lse_sl
11323: WHERE cle_sl.dnz_chr_id = p_chr_id
11324: AND cle_sl.cle_id = cle.ID
11325: AND cle_sl.lse_id = lse_sl.ID

Line 12495: FROM okc_k_lines_v kle,

12491: p_khr_id IN NUMBER
12492: )
12493: IS
12494: SELECT kle.ID ID
12495: FROM okc_k_lines_v kle,
12496: okc_k_headers_v khr
12497: WHERE kle.dnz_chr_id = p_khr_id
12498: AND kle.sts_code = khr.sts_code
12499: AND kle.chr_id = khr.ID;

Line 12933: FROM okc_k_lines_v kle,

12929: p_khr_id IN NUMBER
12930: )
12931: IS
12932: SELECT kle.ID ID
12933: FROM okc_k_lines_v kle,
12934: okc_k_headers_v khr,
12935: okc_line_styles_v lse
12936: WHERE kle.dnz_chr_id = p_khr_id
12937: AND kle.dnz_chr_id = khr.ID