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

Line 2525: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b

2521: --cursor to fetch the corporate and tax book for the given asset
2522: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS
2523: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
2524: o.dnz_chr_id ,a.book_type_code, b.book_class, a.prorate_convention_code
2525: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
2526: WHERE o.parent_line_id = p_kle_id
2527: AND o.asset_id = a.asset_id
2528: AND a.book_type_code = b.book_type_code
2529: AND a.date_ineffective IS NULL

Line 11062: FROM FA_books

11058: ,DEPRECIATE_FLAG
11059: --Bug# 6152614
11060: ,PRORATE_CONVENTION_CODE
11061: ,PRORATE_DATE
11062: FROM FA_books
11063: WHERE asset_id = p_asset_id
11064: AND book_type_code = p_book_type_code
11065: AND transaction_header_id_out IS NULL;
11066:

Line 11067: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;

11063: WHERE asset_id = p_asset_id
11064: AND book_type_code = p_book_type_code
11065: AND transaction_header_id_out IS NULL;
11066:
11067: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;
11068: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;
11069: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11070: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11071: -- Bug# 5946411 -- end

Line 11068: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;

11064: AND book_type_code = p_book_type_code
11065: AND transaction_header_id_out IS NULL;
11066:
11067: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;
11068: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;
11069: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11070: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11071: -- Bug# 5946411 -- end
11072: -- Bug# 6152614

Line 11069: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;

11065: AND transaction_header_id_out IS NULL;
11066:
11067: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;
11068: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;
11069: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11070: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11071: -- Bug# 5946411 -- end
11072: -- Bug# 6152614
11073: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;

Line 11070: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;

11066:
11067: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;
11068: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;
11069: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11070: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11071: -- Bug# 5946411 -- end
11072: -- Bug# 6152614
11073: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;
11074: l_prorate_date FA_books.PRORATE_DATE%TYPE;

Line 11073: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;

11069: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11070: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11071: -- Bug# 5946411 -- end
11072: -- Bug# 6152614
11073: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;
11074: l_prorate_date FA_books.PRORATE_DATE%TYPE;
11075:
11076: --cursor to fetch already created asset id if book_class is TAX ie. corp book is already created
11077: CURSOR get_ast_id_cur (p_asset_number IN VARCHAR2,

Line 11074: l_prorate_date FA_books.PRORATE_DATE%TYPE;

11070: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11071: -- Bug# 5946411 -- end
11072: -- Bug# 6152614
11073: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;
11074: l_prorate_date FA_books.PRORATE_DATE%TYPE;
11075:
11076: --cursor to fetch already created asset id if book_class is TAX ie. corp book is already created
11077: CURSOR get_ast_id_cur (p_asset_number IN VARCHAR2,
11078: p_book_type_code IN VARCHAR2) IS

Line 12311: fa_books inbk,

12307: --cursor to get the amortization date
12308: cursor l_max_amortize_date_csr (p_asset_id IN NUMBER,p_book_type_code IN VARCHAR2) is
12309: select max(th.amortization_start_date) amortization_start_date
12310: from fa_transaction_headers th,
12311: fa_books inbk,
12312: fa_books outbk
12313: where inbk.asset_id = p_asset_id
12314: and inbk.book_type_code = p_book_type_code
12315: and outbk.asset_id(+) = p_asset_id

Line 12312: fa_books outbk

12308: cursor l_max_amortize_date_csr (p_asset_id IN NUMBER,p_book_type_code IN VARCHAR2) is
12309: select max(th.amortization_start_date) amortization_start_date
12310: from fa_transaction_headers th,
12311: fa_books inbk,
12312: fa_books outbk
12313: where inbk.asset_id = p_asset_id
12314: and inbk.book_type_code = p_book_type_code
12315: and outbk.asset_id(+) = p_asset_id
12316: and outbk.book_type_code(+) = p_book_type_code