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_SEEDED_FUNCTIONS_PVT dependencies on OKL_ASSET_COMPONENTS_B

Line 15410: FROM OKL_ASSET_COMPONENTS_B ASSETCOMP

15406: RETURN NUMBER IS
15407: --cursor to get asset cost
15408: CURSOR c_asset_cost (p_asset_id IN NUMBER) IS
15409: SELECT (ASSETCOMP.NUMBER_OF_UNITS * ASSETCOMP.UNIT_COST) AST_COST
15410: FROM OKL_ASSET_COMPONENTS_B ASSETCOMP
15411: WHERE ASSETCOMP.PRIMARY_COMPONENT = 'YES'
15412: AND ASSETCOMP.ASSET_ID = p_asset_id;
15413:
15414: --cursor to get asset Add-On amount

Line 15417: FROM OKL_ASSET_COMPONENTS_B ASSETCOMP

15413:
15414: --cursor to get asset Add-On amount
15415: CURSOR c_addOn_cost (p_asset_id IN NUMBER) IS
15416: SELECT sum(ASSETCOMP.NUMBER_OF_UNITS * ASSETCOMP.UNIT_COST) ADDON_AMNT
15417: FROM OKL_ASSET_COMPONENTS_B ASSETCOMP
15418: WHERE ASSETCOMP.PRIMARY_COMPONENT = 'NO'
15419: AND ASSETCOMP.ASSET_ID = p_asset_id;
15420:
15421: -- cursor to get capitalized fee amount for the asset