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_LINE_STYLES_B

Line 2372: okc_line_styles_b lty_fin,

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'
2376: AND txl.tas_id = trx.ID

Line 2373: okc_line_styles_b lty_fix

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'
2376: AND txl.tas_id = trx.ID
2377: AND kle_fin.lse_id = lty_fin.ID

Line 2428: okc_line_styles_b lse

2424: )
2425: IS
2426: SELECT 'Y' a
2427: FROM okl_k_lines_full_v kle,
2428: okc_line_styles_b lse
2429: WHERE kle.NAME = p_asset_number
2430: AND kle.lse_id = lse.ID
2431: AND lse.lty_code = 'FIXED_ASSET';
2432: BEGIN

Line 3893: okc_line_styles_b lse

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
3894: WHERE hdrcle.chr_id = p_chr_id
3895: AND cle.cle_id = hdrcle.ID
3896: AND cim.dnz_chr_id = cle.dnz_chr_id
3897: AND cim.jtot_object1_code = 'OKX_COVASST'

Line 9755: okc_line_styles_b lse,

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
9759: AND cim.cle_id = cle.ID

Line 9773: okc_line_styles_b line_styl,

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
9777: AND line_styl.lty_code = cp_line_type

Line 9800: okc_line_styles_b lse,

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
9804: AND cim.cle_id = cle.ID

Line 11207: okc_line_styles_b lse

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
11211: AND lse.lse_type = g_tls_type

Line 11239: okc_line_styles_b lse

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
11243: (g_ser_line_lty_code,

Line 11263: okc_line_styles_b lse

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
11266: AND cle.lse_id = lse.ID
11267: AND lse.lty_code IN (g_srl_line_lty_code, g_fel_line_lty_code)

Line 11283: okc_line_styles_b lse

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
11286: AND cle.lse_id = lse.ID
11287: AND lse.lty_code IN (g_srl_line_lty_code, g_fel_line_lty_code)

Line 11304: okc_line_styles_b lse

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
11308: AND lse.lty_code IN (g_ser_line_lty_code, g_fee_line_lty_code)

Line 11322: okc_line_styles_b lse_sl

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
11326: AND cle_sl.sts_code <> p_sts_code