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 2553: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b

2549: --cursor to fetch the corporate and tax book for the given asset
2550: CURSOR l_okxassetlines_csr(p_kle_id IN NUMBER) IS
2551: SELECT o.asset_id, o.asset_number, o.corporate_book, a.cost, o.depreciation_category, a.original_cost, o.current_units,
2552: o.dnz_chr_id ,a.book_type_code, b.book_class, a.prorate_convention_code
2553: FROM okx_asset_lines_v o, fa_books a, fa_book_controls b
2554: WHERE o.parent_line_id = p_kle_id
2555: AND o.asset_id = a.asset_id
2556: AND a.book_type_code = b.book_type_code
2557: AND a.date_ineffective IS NULL

Line 11115: FROM FA_books

11111: ,DEPRECIATE_FLAG
11112: --Bug# 6152614
11113: ,PRORATE_CONVENTION_CODE
11114: ,PRORATE_DATE
11115: FROM FA_books
11116: WHERE asset_id = p_asset_id
11117: AND book_type_code = p_book_type_code
11118: AND transaction_header_id_out IS NULL;
11119:

Line 11120: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;

11116: WHERE asset_id = p_asset_id
11117: AND book_type_code = p_book_type_code
11118: AND transaction_header_id_out IS NULL;
11119:
11120: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;
11121: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;
11122: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11123: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11124: -- Bug# 5946411 -- end

Line 11121: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;

11117: AND book_type_code = p_book_type_code
11118: AND transaction_header_id_out IS NULL;
11119:
11120: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;
11121: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;
11122: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11123: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11124: -- Bug# 5946411 -- end
11125: -- Bug# 6152614

Line 11122: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;

11118: AND transaction_header_id_out IS NULL;
11119:
11120: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;
11121: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;
11122: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11123: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11124: -- Bug# 5946411 -- end
11125: -- Bug# 6152614
11126: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;

Line 11123: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;

11119:
11120: l_allowed_deprn_limit FA_books.ALLOWED_DEPRN_LIMIT%TYPE;
11121: l_allowed_deprn_limit_amount FA_books.allowed_deprn_limit_amount%type;
11122: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11123: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11124: -- Bug# 5946411 -- end
11125: -- Bug# 6152614
11126: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;
11127: l_prorate_date FA_books.PRORATE_DATE%TYPE;

Line 11126: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;

11122: l_deprn_limit_type FA_books.DEPRN_LIMIT_TYPE%TYPE;
11123: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11124: -- Bug# 5946411 -- end
11125: -- Bug# 6152614
11126: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;
11127: l_prorate_date FA_books.PRORATE_DATE%TYPE;
11128:
11129: --cursor to fetch already created asset id if book_class is TAX ie. corp book is already created
11130: CURSOR get_ast_id_cur (p_asset_number IN VARCHAR2,

Line 11127: l_prorate_date FA_books.PRORATE_DATE%TYPE;

11123: l_depreciate_flag FA_books.DEPRECIATE_FLAG%TYPE;
11124: -- Bug# 5946411 -- end
11125: -- Bug# 6152614
11126: l_prorate_convention_code FA_books.PRORATE_CONVENTION_CODE%TYPE;
11127: l_prorate_date FA_books.PRORATE_DATE%TYPE;
11128:
11129: --cursor to fetch already created asset id if book_class is TAX ie. corp book is already created
11130: CURSOR get_ast_id_cur (p_asset_number IN VARCHAR2,
11131: p_book_type_code IN VARCHAR2) IS

Line 12364: fa_books inbk,

12360: --cursor to get the amortization date
12361: cursor l_max_amortize_date_csr (p_asset_id IN NUMBER,p_book_type_code IN VARCHAR2) is
12362: select max(th.amortization_start_date) amortization_start_date
12363: from fa_transaction_headers th,
12364: fa_books inbk,
12365: fa_books outbk
12366: where inbk.asset_id = p_asset_id
12367: and inbk.book_type_code = p_book_type_code
12368: and outbk.asset_id(+) = p_asset_id

Line 12365: fa_books outbk

12361: cursor l_max_amortize_date_csr (p_asset_id IN NUMBER,p_book_type_code IN VARCHAR2) is
12362: select max(th.amortization_start_date) amortization_start_date
12363: from fa_transaction_headers th,
12364: fa_books inbk,
12365: fa_books outbk
12366: where inbk.asset_id = p_asset_id
12367: and inbk.book_type_code = p_book_type_code
12368: and outbk.asset_id(+) = p_asset_id
12369: and outbk.book_type_code(+) = p_book_type_code