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 14178: FROM OKL_ASSET_COMPONENTS_B ASSETCOMP

14174: RETURN NUMBER IS
14175: --cursor to get asset cost
14176: CURSOR c_asset_cost (p_asset_id IN NUMBER) IS
14177: SELECT (ASSETCOMP.NUMBER_OF_UNITS * ASSETCOMP.UNIT_COST) AST_COST
14178: FROM OKL_ASSET_COMPONENTS_B ASSETCOMP
14179: WHERE ASSETCOMP.PRIMARY_COMPONENT = 'YES'
14180: AND ASSETCOMP.ASSET_ID = p_asset_id;
14181:
14182: --cursor to get asset Add-On amount

Line 14185: FROM OKL_ASSET_COMPONENTS_B ASSETCOMP

14181:
14182: --cursor to get asset Add-On amount
14183: CURSOR c_addOn_cost (p_asset_id IN NUMBER) IS
14184: SELECT sum(ASSETCOMP.NUMBER_OF_UNITS * ASSETCOMP.UNIT_COST) ADDON_AMNT
14185: FROM OKL_ASSET_COMPONENTS_B ASSETCOMP
14186: WHERE ASSETCOMP.PRIMARY_COMPONENT = 'NO'
14187: AND ASSETCOMP.ASSET_ID = p_asset_id;
14188:
14189: -- cursor to get capitalized fee amount for the asset