DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on FA_BOOK_CONTROLS

Line 1404: FA_BOOK_CONTROLS,

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
1408: where FA_BOOKS.asset_id = KITEM.OBJECT1_ID1

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 1415: and FA_BOOK_CONTROLS.book_class = 'CORPORATE'

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,
1419: p_book_type_code IN VARCHAR2) IS