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 11184: p_cle_id IN okc_k_lines_b.ID%TYPE

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

Line 11188: FROM okc_k_lines_b cle

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

Line 11198: p_cle_id IN okc_k_lines_b.ID%TYPE

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

Line 11207: FROM okc_k_lines_b cle,

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

Line 11224: FROM okc_k_lines_b kle

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

Line 11239: FROM okc_k_lines_b cle,

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

Line 11262: FROM okc_k_lines_b cle,

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

Line 11282: FROM okc_k_lines_b cle,

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

Line 11385: p_cle_id IN okc_k_lines_b.ID%TYPE,

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

Line 11386: p_dnz_chr_id IN okc_k_lines_b.dnz_chr_id%TYPE

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