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_VARIABLE_INTEREST_PVT dependencies on FA_BOOKS

Line 1400: Select FA_BOOKS.ASSET_ID ASSET_ID,

1396: */
1397: l_net_book_value NUMBER := 0;
1398:
1399: Cursor lease_asset_cost_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
1400: Select FA_BOOKS.ASSET_ID ASSET_ID,
1401: FA_BOOKS.cost ASSET_COST,
1402: FA_BOOKS.book_type_code BOOK_TYPE_CODE
1403: from FA_BOOKS ,
1404: FA_BOOK_CONTROLS,

Line 1401: FA_BOOKS.cost ASSET_COST,

1397: l_net_book_value NUMBER := 0;
1398:
1399: Cursor lease_asset_cost_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
1400: Select FA_BOOKS.ASSET_ID ASSET_ID,
1401: FA_BOOKS.cost ASSET_COST,
1402: FA_BOOKS.book_type_code BOOK_TYPE_CODE
1403: from FA_BOOKS ,
1404: FA_BOOK_CONTROLS,
1405: OKC_K_LINES_B LINES,

Line 1402: FA_BOOKS.book_type_code BOOK_TYPE_CODE

1398:
1399: Cursor lease_asset_cost_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
1400: Select FA_BOOKS.ASSET_ID ASSET_ID,
1401: FA_BOOKS.cost ASSET_COST,
1402: FA_BOOKS.book_type_code BOOK_TYPE_CODE
1403: from FA_BOOKS ,
1404: FA_BOOK_CONTROLS,
1405: OKC_K_LINES_B LINES,
1406: OKC_LINE_STYLES_B STYLE,

Line 1403: from FA_BOOKS ,

1399: Cursor lease_asset_cost_csr (p_chr_id IN NUMBER, p_kle_id IN NUMBER) IS
1400: Select FA_BOOKS.ASSET_ID ASSET_ID,
1401: FA_BOOKS.cost ASSET_COST,
1402: FA_BOOKS.book_type_code BOOK_TYPE_CODE
1403: from FA_BOOKS ,
1404: FA_BOOK_CONTROLS,
1405: OKC_K_LINES_B LINES,
1406: OKC_LINE_STYLES_B STYLE,
1407: OKC_K_ITEMS KITEM

Line 1408: where FA_BOOKS.asset_id = KITEM.OBJECT1_ID1

1404: FA_BOOK_CONTROLS,
1405: OKC_K_LINES_B LINES,
1406: OKC_LINE_STYLES_B STYLE,
1407: OKC_K_ITEMS KITEM
1408: where FA_BOOKS.asset_id = KITEM.OBJECT1_ID1
1409: and LINES.DNZ_CHR_ID = p_chr_id --291511068054787299132375269533568315520
1410: and LINES.cle_id = p_kle_id
1411: and LINES.ID = KITEM.CLE_ID
1412: and LINES.LSE_ID = STYLE.ID

Line 1414: and FA_BOOKS.book_type_code = FA_BOOK_CONTROLS.book_type_code

1410: and LINES.cle_id = p_kle_id
1411: and LINES.ID = KITEM.CLE_ID
1412: and LINES.LSE_ID = STYLE.ID
1413: and STYLE.LTY_CODE = 'FIXED_ASSET'
1414: and FA_BOOKS.book_type_code = FA_BOOK_CONTROLS.book_type_code
1415: and FA_BOOK_CONTROLS.book_class = 'CORPORATE'
1416: and FA_BOOKS.transaction_header_id_out is null;
1417:
1418: Cursor Deprn_csr (p_asset_id IN NUMBER,

Line 1416: and FA_BOOKS.transaction_header_id_out is null;

1412: and LINES.LSE_ID = STYLE.ID
1413: and STYLE.LTY_CODE = 'FIXED_ASSET'
1414: and FA_BOOKS.book_type_code = FA_BOOK_CONTROLS.book_type_code
1415: and FA_BOOK_CONTROLS.book_class = 'CORPORATE'
1416: and FA_BOOKS.transaction_header_id_out is null;
1417:
1418: Cursor Deprn_csr (p_asset_id IN NUMBER,
1419: p_book_type_code IN VARCHAR2) IS
1420: select sum(deprn_amount) ACCUMULATED_DEPRECIATION