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_LIKE_KIND_EXCHANGE_PVT dependencies on OKL_LIKE_KIND_EXCHANGE_V

Line 49: FROM OKL_LIKE_KIND_EXCHANGE_V

45: l_sale_proceeds NUMBER;
46:
47: CURSOR get_sale_proceeds_csr (p_req_asset_id NUMBER, p_tax_book_code VARCHAR2) IS
48: SELECT proceeds_of_sale
49: FROM OKL_LIKE_KIND_EXCHANGE_V
50: WHERE asset_id = p_req_asset_id
51: AND book_type_code = p_tax_book_code;
52:
53: BEGIN

Line 90: FROM OKL_LIKE_KIND_EXCHANGE_V

86: l_deferred_gain NUMBER;
87:
88: CURSOR get_orig_amounts_csr (p_req_asset_id NUMBER, p_tax_book_code VARCHAR2) IS
89: SELECT proceeds_of_sale, gain_loss_amount
90: FROM OKL_LIKE_KIND_EXCHANGE_V
91: WHERE asset_id = p_req_asset_id
92: AND book_type_code = p_tax_book_code;
93:
94: BEGIN

Line 418: p_book_type_code IN OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE,

414: x_return_status OUT NOCOPY VARCHAR2,
415: x_msg_count OUT NOCOPY NUMBER,
416: x_msg_data OUT NOCOPY VARCHAR2,
417: p_asset_id IN NUMBER,
418: p_book_type_code IN OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE,
419: p_adjust_cost IN NUMBER,
420: x_asset_fin_rec OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS
421:
422:

Line 439: l_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE := p_book_type_code;

435: l_inv_rec FA_API_TYPES.inv_rec_type;
436: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
437: l_group_recalss_option_rec FA_API_TYPES.group_reclass_options_rec_type;
438: l_asset_id NUMBER := p_asset_id;
439: l_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE := p_book_type_code;
440: l_adjust_cost NUMBER := p_adjust_cost;
441: BEGIN
442: -- Call start_activity to create savepoint, check compatibility
443: -- and initialize message list

Line 583: CURSOR get_asset_corp_details_csr(p_asset_id OKL_LIKE_KIND_EXCHANGE_V.ASSET_ID%TYPE

579: WHERE NAME = l_try_name
580: AND LANGUAGE = 'US';
581:
582: -- cursor to get relinquished asset corporate details
583: CURSOR get_asset_corp_details_csr(p_asset_id OKL_LIKE_KIND_EXCHANGE_V.ASSET_ID%TYPE
584: ,p_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE) IS
585: SELECT *
586: FROM OKL_LIKE_KIND_EXCHANGE_V
587: WHERE ASSET_ID = p_asset_id

Line 584: ,p_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE) IS

580: AND LANGUAGE = 'US';
581:
582: -- cursor to get relinquished asset corporate details
583: CURSOR get_asset_corp_details_csr(p_asset_id OKL_LIKE_KIND_EXCHANGE_V.ASSET_ID%TYPE
584: ,p_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE) IS
585: SELECT *
586: FROM OKL_LIKE_KIND_EXCHANGE_V
587: WHERE ASSET_ID = p_asset_id
588: AND BOOK_TYPE_CODE = p_book_type_code;

Line 586: FROM OKL_LIKE_KIND_EXCHANGE_V

582: -- cursor to get relinquished asset corporate details
583: CURSOR get_asset_corp_details_csr(p_asset_id OKL_LIKE_KIND_EXCHANGE_V.ASSET_ID%TYPE
584: ,p_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE) IS
585: SELECT *
586: FROM OKL_LIKE_KIND_EXCHANGE_V
587: WHERE ASSET_ID = p_asset_id
588: AND BOOK_TYPE_CODE = p_book_type_code;
589:
590: -- cursor to get relinquished asset tax details

Line 591: CURSOR get_asset_tax_details_csr(p_asset_id OKL_LIKE_KIND_EXCHANGE_V.ASSET_ID%TYPE

587: WHERE ASSET_ID = p_asset_id
588: AND BOOK_TYPE_CODE = p_book_type_code;
589:
590: -- cursor to get relinquished asset tax details
591: CURSOR get_asset_tax_details_csr(p_asset_id OKL_LIKE_KIND_EXCHANGE_V.ASSET_ID%TYPE
592: ,p_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE) IS
593: SELECT *
594: FROM OKL_LIKE_KIND_EXCHANGE_V
595: WHERE ASSET_ID = p_asset_id

Line 592: ,p_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE) IS

588: AND BOOK_TYPE_CODE = p_book_type_code;
589:
590: -- cursor to get relinquished asset tax details
591: CURSOR get_asset_tax_details_csr(p_asset_id OKL_LIKE_KIND_EXCHANGE_V.ASSET_ID%TYPE
592: ,p_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE) IS
593: SELECT *
594: FROM OKL_LIKE_KIND_EXCHANGE_V
595: WHERE ASSET_ID = p_asset_id
596: AND BOOK_TYPE_CODE = p_book_type_code;

Line 594: FROM OKL_LIKE_KIND_EXCHANGE_V

590: -- cursor to get relinquished asset tax details
591: CURSOR get_asset_tax_details_csr(p_asset_id OKL_LIKE_KIND_EXCHANGE_V.ASSET_ID%TYPE
592: ,p_book_type_code OKL_LIKE_KIND_EXCHANGE_V.BOOK_TYPE_CODE%TYPE) IS
593: SELECT *
594: FROM OKL_LIKE_KIND_EXCHANGE_V
595: WHERE ASSET_ID = p_asset_id
596: AND BOOK_TYPE_CODE = p_book_type_code;
597:
598: --Cursor to chk book validity for an asset category