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_B

Line 3877: p_qte_id IN okc_k_lines_b.ID%TYPE

3873: -- Used to get Assets selected for termination and
3874: -- Fee and Sold Service lines associated to the assets
3875: CURSOR k_asst_fee_srvc_lns_csr (
3876: p_chr_id IN okc_k_headers_b.ID%TYPE,
3877: p_qte_id IN okc_k_lines_b.ID%TYPE
3878: )
3879: IS
3880: SELECT cle.ID cle_id
3881: FROM okc_k_lines_b cle,

Line 3881: FROM okc_k_lines_b cle,

3877: p_qte_id IN okc_k_lines_b.ID%TYPE
3878: )
3879: IS
3880: SELECT cle.ID cle_id
3881: FROM okc_k_lines_b cle,
3882: okl_txl_quote_lines_b tql
3883: WHERE tql.qte_id = p_qte_id
3884: AND tql.qlt_code = 'AMCFIA'
3885: AND tql.kle_id = cle.ID

Line 3888: FROM okc_k_lines_b cle,

3884: AND tql.qlt_code = 'AMCFIA'
3885: AND tql.kle_id = cle.ID
3886: UNION
3887: SELECT DISTINCT hdrcle.ID cle_id
3888: FROM okc_k_lines_b cle,
3889: okc_k_lines_b hdrcle,
3890: okc_k_items cim,
3891: okl_txl_quote_lines_b tql,
3892: okc_k_headers_b CHR,

Line 3889: okc_k_lines_b hdrcle,

3885: AND tql.kle_id = cle.ID
3886: UNION
3887: SELECT DISTINCT hdrcle.ID cle_id
3888: FROM okc_k_lines_b cle,
3889: okc_k_lines_b hdrcle,
3890: okc_k_items cim,
3891: okl_txl_quote_lines_b tql,
3892: okc_k_headers_b CHR,
3893: okc_line_styles_b lse

Line 9754: FROM okc_k_lines_b cle,

9750: )
9751: IS
9752: SELECT cim.object1_id1,
9753: cle.cle_id
9754: FROM okc_k_lines_b cle,
9755: okc_line_styles_b lse,
9756: okc_k_items cim
9757: WHERE cle.lse_id = lse.ID
9758: AND lse.lty_code = cp_line_type

Line 9772: FROM okc_k_lines_b linked_asset,

9768: cp_line_type IN VARCHAR2
9769: )
9770: IS
9771: SELECT 'X'
9772: FROM okc_k_lines_b linked_asset,
9773: okc_line_styles_b line_styl,
9774: okc_k_items item,
9775: okc_statuses_b sts
9776: WHERE linked_asset.lse_id = line_styl.ID

Line 9799: FROM okc_k_lines_b cle,

9795: )
9796: IS
9797: SELECT cim.object1_id1,
9798: cle.ID
9799: FROM okc_k_lines_b cle,
9800: okc_line_styles_b lse,
9801: okc_k_items cim
9802: WHERE cle.lse_id = lse.ID
9803: AND lse.lty_code = cp_line_type

Line 11183: p_cle_id IN okc_k_lines_b.ID%TYPE

11179: IS
11180: -- RMUNJULU Bug # 2484327 changed parameters to IN
11181: -- We need to change the status of lines
11182: CURSOR l_trmnt_line_csr (
11183: p_cle_id IN okc_k_lines_b.ID%TYPE
11184: )
11185: IS
11186: SELECT cle.ID ID
11187: FROM okc_k_lines_b cle

Line 11187: FROM okc_k_lines_b cle

11183: p_cle_id IN okc_k_lines_b.ID%TYPE
11184: )
11185: IS
11186: SELECT cle.ID ID
11187: FROM okc_k_lines_b cle
11188: CONNECT BY PRIOR cle.ID = cle.cle_id
11189: START WITH cle.ID = p_cle_id;
11190:
11191: -- RMUNJULU Bug # 2484327 changed parameters to IN

Line 11197: p_cle_id IN okc_k_lines_b.ID%TYPE

11193: -- Based Billing lines
11194: CURSOR l_get_sls_csr (
11195: p_chr_id IN okc_k_headers_b.ID%TYPE,
11196: p_sts_code IN okc_k_headers_b.sts_code%TYPE,
11197: p_cle_id IN okc_k_lines_b.ID%TYPE
11198: )
11199: IS
11200: SELECT cim.cle_id cle_id
11201: FROM okc_k_items cim

Line 11206: FROM okc_k_lines_b cle,

11202: WHERE cim.dnz_chr_id = p_chr_id
11203: AND cim.jtot_object1_code = 'OKX_COVASST'
11204: AND cim.object1_id1 IN (
11205: SELECT cle.ID
11206: FROM okc_k_lines_b cle,
11207: okc_line_styles_b lse
11208: WHERE cle.dnz_chr_id = p_chr_id
11209: AND cle.lse_id = lse.ID
11210: AND lse.lty_code = g_fin_line_lty_code

Line 11223: FROM okc_k_lines_b kle

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
11224: WHERE kle.cle_id = p_cle_id;
11225:
11226: -- RMUNJULU Bug # 2484327 changed parameters to IN
11227: -- We need to find out weahter we have fee, service, and Usage lines first

Line 11238: FROM okc_k_lines_b cle,

11234: SELECT '1'
11235: FROM DUAL
11236: WHERE EXISTS (
11237: SELECT '1'
11238: FROM okc_k_lines_b cle,
11239: okc_line_styles_b lse
11240: WHERE cle.dnz_chr_id = p_chr_id
11241: AND lse.ID = cle.lse_id
11242: AND lse.lty_code IN

Line 11261: FROM okc_k_lines_b cle,

11257: )
11258: IS
11259: SELECT SUM (kle.capital_amount) amount,
11260: cle.cle_id cle_id
11261: FROM okc_k_lines_b cle,
11262: okl_k_lines kle,
11263: okc_line_styles_b lse
11264: WHERE kle.ID = cle.ID
11265: AND cle.dnz_chr_id = p_chr_id

Line 11281: FROM okc_k_lines_b cle,

11277: )
11278: IS
11279: SELECT SUM (kle.capital_amount) amount,
11280: cle.cle_id cle_id
11281: FROM okc_k_lines_b cle,
11282: okl_k_lines kle,
11283: okc_line_styles_b lse
11284: WHERE kle.ID = cle.ID
11285: AND cle.dnz_chr_id = p_chr_id

Line 11384: p_cle_id IN okc_k_lines_b.ID%TYPE,

11380: -- RMUNJULU Bug # 2484327 Added comments, changed parameters to IN
11381: -- We need to find out the object1_id1 and object1_id2 and jtot_object1_code
11382: -- to get the name of the fee or service or ubb line based on jtot_object1_code
11383: CURSOR l_item_line_csr (
11384: p_cle_id IN okc_k_lines_b.ID%TYPE,
11385: p_dnz_chr_id IN okc_k_lines_b.dnz_chr_id%TYPE
11386: )
11387: IS
11388: SELECT cim.object1_id1 object1_id1,

Line 11385: p_dnz_chr_id IN okc_k_lines_b.dnz_chr_id%TYPE

11381: -- We need to find out the object1_id1 and object1_id2 and jtot_object1_code
11382: -- to get the name of the fee or service or ubb line based on jtot_object1_code
11383: CURSOR l_item_line_csr (
11384: p_cle_id IN okc_k_lines_b.ID%TYPE,
11385: p_dnz_chr_id IN okc_k_lines_b.dnz_chr_id%TYPE
11386: )
11387: IS
11388: SELECT cim.object1_id1 object1_id1,
11389: cim.object1_id2 object1_id2,