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_CREATE_KLE_PVT dependencies on OKL_ASSET_RETURNS_ALL_B

Line 2568: FROM okl_asset_returns_all_b KAR

2564: AND RULE_INFORMATION_CATEGORY = 'LARLES';*/
2565:
2566: CURSOR c_check_release_asset(p_asset_number IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2567: SELECT 'Y'
2568: FROM okl_asset_returns_all_b KAR
2569: WHERE KAR.kle_id IN (SELECT KLE.cle_id
2570: FROM okl_txl_assets_b TXL
2571: ,okl_txd_assets_b TXD
2572: ,okc_k_lines_b KLE

Line 2929: FROM okl_asset_returns_all_b KAR

2925: AND RULE_INFORMATION_CATEGORY = 'LARLES';*/
2926:
2927: CURSOR c_check_release_asset(p_asset_number IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2928: SELECT 'Y'
2929: FROM okl_asset_returns_all_b KAR
2930: WHERE KAR.kle_id IN (SELECT KLE.cle_id
2931: FROM okl_txl_assets_b TXL
2932: ,okl_txd_assets_b TXD
2933: ,okc_k_lines_b KLE

Line 15279: FROM okl_asset_returns_all_b KAR

15275: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
15276: and chr.ID = p_chr_id
15277: AND EXISTS (
15278: SELECT '1'
15279: FROM okl_asset_returns_all_b KAR
15280: WHERE KAR.kle_id IN (SELECT KLE.cle_id
15281: FROM okl_txl_assets_b TXL
15282: ,okl_txd_assets_b TXD
15283: ,okc_k_lines_b KLE