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 1191: okc_line_styles_b lse_model,

1187: From
1188: --inv item and org
1189: okc_k_lines_b cleb,
1190: okc_k_lines_b cle_model,
1191: okc_line_styles_b lse_model,
1192: okc_k_items cim_model,
1193: okl_subsidy_criteria suc
1194: where cim_model.cle_id = cle_model.id
1195: And cim_model.dnz_chr_id = cleb.dnz_chr_id

Line 1265: okc_line_styles_b lse_ib,

1261: okl_txl_itm_insts iti,
1262: --csi_item_instances csii,
1263: --okc_k_items cim_ib,
1264: okc_k_lines_b cle_ib,
1265: okc_line_styles_b lse_ib,
1266: okc_k_lines_b cle_inst,
1267: okc_line_styles_b lse_inst,
1268: OKC_K_LINES_B cleb,
1269: okl_subsidy_criteria suc

Line 1267: okc_line_styles_b lse_inst,

1263: --okc_k_items cim_ib,
1264: okc_k_lines_b cle_ib,
1265: okc_line_styles_b lse_ib,
1266: okc_k_lines_b cle_inst,
1267: okc_line_styles_b lse_inst,
1268: OKC_K_LINES_B cleb,
1269: okl_subsidy_criteria suc
1270: Where cle_inst.cle_id = cleb.id
1271: And cle_inst.dnz_chr_id = cleb.dnz_chr_id

Line 1431: OKC_LINE_STYLES_B LTY_FIN,

1427: FROM OKL_TXL_ASSETS_B TXL,
1428: OKL_TRX_ASSETS TRX,
1429: OKC_K_LINES_B KLE_FIN,
1430: OKC_K_LINES_B KLE_FIX,
1431: OKC_LINE_STYLES_B LTY_FIN,
1432: OKC_LINE_STYLES_B LTY_FIX
1433: WHERE TXL.TAL_TYPE = 'ALI' -- identifies split transaction
1434: AND TRX.TSU_CODE = 'ENTERED' -- split transaction in progress
1435: AND TXL.TAS_ID = TRX.ID

Line 1432: OKC_LINE_STYLES_B LTY_FIX

1428: OKL_TRX_ASSETS TRX,
1429: OKC_K_LINES_B KLE_FIN,
1430: OKC_K_LINES_B KLE_FIX,
1431: OKC_LINE_STYLES_B LTY_FIN,
1432: OKC_LINE_STYLES_B LTY_FIX
1433: WHERE TXL.TAL_TYPE = 'ALI' -- identifies split transaction
1434: AND TRX.TSU_CODE = 'ENTERED' -- split transaction in progress
1435: AND TXL.TAS_ID = TRX.ID
1436: AND KLE_FIN.LSE_ID = LTY_FIN.ID

Line 3192: okc_line_styles_b lseb_sub,

3188: select SUM(decode(kle_sub.SUBSIDY_OVERRIDE_AMOUNT,
3189: null, nvl(kle_sub.AMOUNT,0),
3190: kle_sub.SUBSIDY_OVERRIDE_AMOUNT))
3191: from okc_k_lines_b cleb_sub,
3192: okc_line_styles_b lseb_sub,
3193: okl_k_lines kle_sub,
3194: okl_subsidies_b sub
3195: where kle_sub.id = cleb_sub.id And
3196: cleb_sub.lse_id = lseb_sub.id And

Line 3632: okc_line_styles_b lseb

3628: p_subsidy_cle_id IN NUMBER) IS
3629: cursor l_subcle_csr (p_subsidy_cle_id in number) is
3630: select 'Y'
3631: from okc_k_lines_b cleb,
3632: okc_line_styles_b lseb
3633: where cleb.id = p_subsidy_cle_id
3634: and lseb.id = cleb.lse_id
3635: and lseb.lty_code = 'SUBSIDY'
3636: and cleb.sts_code <> 'ABANDONED';

Line 3878: okc_line_styles_b lseb,

3874: clet_asst.name asset_number
3875: from okl_k_lines kle,
3876: okc_k_lines_tl clet,
3877: okc_k_lines_b cleb,
3878: okc_line_styles_b lseb,
3879: okc_k_lines_tl clet_asst
3880: where kle.id = cleb.id
3881: and kle.subsidy_id = p_subsidy_id
3882: and clet.id = cleb.id

Line 3904: okc_line_styles_b sub_lseb

3900: where subb.id = p_subsidy_id
3901: and nvl(subb.exclusive_yn,'N') = 'Y'
3902: and exists (select '1'
3903: from okc_k_lines_b sub_cleb,
3904: okc_line_styles_b sub_lseb
3905: where sub_cleb.cle_id = p_asset_cle_id
3906: and sub_cleb.sts_code <> 'ABANDONED'
3907: and sub_cleb.id <> nvl(p_subsidy_cle_id,-999)
3908: and sub_lseb.id = sub_cleb.lse_id

Line 4064: okc_line_styles_b lseb,

4060: clet_asst.name asset_number
4061: from okl_k_lines kle,
4062: okc_k_lines_tl clet,
4063: okc_k_lines_b cleb,
4064: okc_line_styles_b lseb,
4065: okc_k_lines_tl clet_asst
4066: where kle.id = cleb.id
4067: and kle.subsidy_id = p_subsidy_id
4068: and clet.id = cleb.id

Line 4095: okc_line_styles_b sub_lseb

4091: where subb.id = p_subsidy_id
4092: and nvl(subb.exclusive_yn,'N') = 'Y'
4093: and exists (select '1'
4094: from okc_k_lines_b sub_cleb,
4095: okc_line_styles_b sub_lseb
4096: where sub_cleb.cle_id = p_asset_cle_id
4097: and sub_cleb.sts_code <> 'ABANDONED'
4098: and sub_cleb.id <> nvl(p_subsidy_cle_id,-999)
4099: and sub_lseb.id = sub_cleb.lse_id

Line 4109: okc_line_styles_b sub_lseb,

4105: Select 'Y',
4106: subb.name
4107: from okl_subsidies_b subb,
4108: okc_k_lines_b sub_cleb,
4109: okc_line_styles_b sub_lseb,
4110: okl_k_lines sub_kleb
4111: where sub_cleb.cle_id = p_asset_cle_id
4112: and sub_cleb.sts_code <> 'ABANDONED'
4113: and sub_lseb.id = sub_cleb.lse_id

Line 4125: okc_line_styles_b sub_lseb,

4121: cursor l_exclusive_csr2(p_asset_cle_id in number) is
4122: select count(1)
4123: from okl_subsidies_b subb,
4124: okc_k_lines_b sub_cleb,
4125: okc_line_styles_b sub_lseb,
4126: okl_k_lines sub_kleb
4127: where sub_cleb.cle_id = p_asset_cle_id
4128: and sub_cleb.sts_code <> 'ABANDONED'
4129: and sub_lseb.id = sub_cleb.lse_id