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_ASSET_SUBSIDY_PVT dependencies on OKC_LINE_STYLES_B

Line 457: from okc_line_styles_b lseb,

453:
454: --cursor to get lse_id
455: cursor l_lseb_csr(p_chr_id in number) is
456: Select lseb.id
457: from okc_line_styles_b lseb,
458: okc_line_styles_b top_lseb,
459: okc_subclass_top_line scs_lse,
460: okc_k_headers_b chrb
461: where lseb.lty_code = G_SUBLINE_LTY_CODE

Line 458: okc_line_styles_b top_lseb,

454: --cursor to get lse_id
455: cursor l_lseb_csr(p_chr_id in number) is
456: Select lseb.id
457: from okc_line_styles_b lseb,
458: okc_line_styles_b top_lseb,
459: okc_subclass_top_line scs_lse,
460: okc_k_headers_b chrb
461: where lseb.lty_code = G_SUBLINE_LTY_CODE
462: and lseb.lse_parent_id = top_lseb.id

Line 1174: okc_line_styles_b lse_model,

1170: From
1171: --inv item and org
1172: okc_k_lines_b cleb,
1173: okc_k_lines_b cle_model,
1174: okc_line_styles_b lse_model,
1175: okc_k_items cim_model,
1176: okl_subsidy_criteria suc
1177: where cim_model.cle_id = cle_model.id
1178: And cim_model.dnz_chr_id = cleb.dnz_chr_id

Line 1248: okc_line_styles_b lse_ib,

1244: okl_txl_itm_insts iti,
1245: --csi_item_instances csii,
1246: --okc_k_items cim_ib,
1247: okc_k_lines_b cle_ib,
1248: okc_line_styles_b lse_ib,
1249: okc_k_lines_b cle_inst,
1250: okc_line_styles_b lse_inst,
1251: OKC_K_LINES_B cleb,
1252: okl_subsidy_criteria suc

Line 1250: okc_line_styles_b lse_inst,

1246: --okc_k_items cim_ib,
1247: okc_k_lines_b cle_ib,
1248: okc_line_styles_b lse_ib,
1249: okc_k_lines_b cle_inst,
1250: okc_line_styles_b lse_inst,
1251: OKC_K_LINES_B cleb,
1252: okl_subsidy_criteria suc
1253: Where cle_inst.cle_id = cleb.id
1254: And cle_inst.dnz_chr_id = cleb.dnz_chr_id

Line 1414: OKC_LINE_STYLES_B LTY_FIN,

1410: FROM OKL_TXL_ASSETS_B TXL,
1411: OKL_TRX_ASSETS TRX,
1412: OKC_K_LINES_B KLE_FIN,
1413: OKC_K_LINES_B KLE_FIX,
1414: OKC_LINE_STYLES_B LTY_FIN,
1415: OKC_LINE_STYLES_B LTY_FIX
1416: WHERE TXL.TAL_TYPE = 'ALI' -- identifies split transaction
1417: AND TRX.TSU_CODE = 'ENTERED' -- split transaction in progress
1418: AND TXL.TAS_ID = TRX.ID

Line 1415: OKC_LINE_STYLES_B LTY_FIX

1411: OKL_TRX_ASSETS TRX,
1412: OKC_K_LINES_B KLE_FIN,
1413: OKC_K_LINES_B KLE_FIX,
1414: OKC_LINE_STYLES_B LTY_FIN,
1415: OKC_LINE_STYLES_B LTY_FIX
1416: WHERE TXL.TAL_TYPE = 'ALI' -- identifies split transaction
1417: AND TRX.TSU_CODE = 'ENTERED' -- split transaction in progress
1418: AND TXL.TAS_ID = TRX.ID
1419: AND KLE_FIN.LSE_ID = LTY_FIN.ID

Line 3171: okc_line_styles_b lseb_sub,

3167: select SUM(decode(kle_sub.SUBSIDY_OVERRIDE_AMOUNT,
3168: null, nvl(kle_sub.AMOUNT,0),
3169: kle_sub.SUBSIDY_OVERRIDE_AMOUNT))
3170: from okc_k_lines_b cleb_sub,
3171: okc_line_styles_b lseb_sub,
3172: okl_k_lines kle_sub,
3173: okl_subsidies_b sub
3174: where kle_sub.id = cleb_sub.id And
3175: cleb_sub.lse_id = lseb_sub.id And

Line 3611: okc_line_styles_b lseb

3607: p_subsidy_cle_id IN NUMBER) IS
3608: cursor l_subcle_csr (p_subsidy_cle_id in number) is
3609: select 'Y'
3610: from okc_k_lines_b cleb,
3611: okc_line_styles_b lseb
3612: where cleb.id = p_subsidy_cle_id
3613: and lseb.id = cleb.lse_id
3614: and lseb.lty_code = 'SUBSIDY'
3615: and cleb.sts_code <> 'ABANDONED';

Line 3857: okc_line_styles_b lseb,

3853: clet_asst.name asset_number
3854: from okl_k_lines kle,
3855: okc_k_lines_tl clet,
3856: okc_k_lines_b cleb,
3857: okc_line_styles_b lseb,
3858: okc_k_lines_tl clet_asst
3859: where kle.id = cleb.id
3860: and kle.subsidy_id = p_subsidy_id
3861: and clet.id = cleb.id

Line 3883: okc_line_styles_b sub_lseb

3879: where subb.id = p_subsidy_id
3880: and nvl(subb.exclusive_yn,'N') = 'Y'
3881: and exists (select '1'
3882: from okc_k_lines_b sub_cleb,
3883: okc_line_styles_b sub_lseb
3884: where sub_cleb.cle_id = p_asset_cle_id
3885: and sub_cleb.sts_code <> 'ABANDONED'
3886: and sub_cleb.id <> nvl(p_subsidy_cle_id,-999)
3887: and sub_lseb.id = sub_cleb.lse_id

Line 4043: okc_line_styles_b lseb,

4039: clet_asst.name asset_number
4040: from okl_k_lines kle,
4041: okc_k_lines_tl clet,
4042: okc_k_lines_b cleb,
4043: okc_line_styles_b lseb,
4044: okc_k_lines_tl clet_asst
4045: where kle.id = cleb.id
4046: and kle.subsidy_id = p_subsidy_id
4047: and clet.id = cleb.id

Line 4074: okc_line_styles_b sub_lseb

4070: where subb.id = p_subsidy_id
4071: and nvl(subb.exclusive_yn,'N') = 'Y'
4072: and exists (select '1'
4073: from okc_k_lines_b sub_cleb,
4074: okc_line_styles_b sub_lseb
4075: where sub_cleb.cle_id = p_asset_cle_id
4076: and sub_cleb.sts_code <> 'ABANDONED'
4077: and sub_cleb.id <> nvl(p_subsidy_cle_id,-999)
4078: and sub_lseb.id = sub_cleb.lse_id

Line 4088: okc_line_styles_b sub_lseb,

4084: Select 'Y',
4085: subb.name
4086: from okl_subsidies_b subb,
4087: okc_k_lines_b sub_cleb,
4088: okc_line_styles_b sub_lseb,
4089: okl_k_lines sub_kleb
4090: where sub_cleb.cle_id = p_asset_cle_id
4091: and sub_cleb.sts_code <> 'ABANDONED'
4092: and sub_lseb.id = sub_cleb.lse_id

Line 4104: okc_line_styles_b sub_lseb,

4100: cursor l_exclusive_csr2(p_asset_cle_id in number) is
4101: select count(1)
4102: from okl_subsidies_b subb,
4103: okc_k_lines_b sub_cleb,
4104: okc_line_styles_b sub_lseb,
4105: okl_k_lines sub_kleb
4106: where sub_cleb.cle_id = p_asset_cle_id
4107: and sub_cleb.sts_code <> 'ABANDONED'
4108: and sub_lseb.id = sub_cleb.lse_id