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 11220: p_cle_id IN okc_k_lines_v.ID%TYPE

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

Line 11256: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,

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

Line 11277: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE

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

Line 11295: p_chr_id IN okc_k_lines_v.dnz_chr_id%TYPE,

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

Line 11296: p_cle_id IN okc_k_lines_v.ID%TYPE,

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

Line 11304: okc_k_lines_v cle,

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

Line 11322: FROM okc_k_lines_v cle_sl,

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

Line 12496: FROM okc_k_lines_v kle,

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

Line 12934: FROM okc_k_lines_v kle,

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