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_CREATE_KLE_PVT dependencies on OKL_TXD_ASSETS_B

Line 2571: ,okl_txd_assets_b TXD

2567: SELECT 'Y'
2568: FROM okl_asset_returns_all_b KAR
2569: WHERE KAR.kle_id IN (SELECT KLE.cle_id
2570: FROM okl_txl_assets_b TXL
2571: ,okl_txd_assets_b TXD
2572: ,okc_k_lines_b KLE
2573: WHERE TXD.asset_number = p_asset_number
2574: AND KLE.id = TXL.kle_id
2575: AND TXL.id = TXD.tal_id )

Line 2932: ,okl_txd_assets_b TXD

2928: SELECT 'Y'
2929: FROM okl_asset_returns_all_b KAR
2930: WHERE KAR.kle_id IN (SELECT KLE.cle_id
2931: FROM okl_txl_assets_b TXL
2932: ,okl_txd_assets_b TXD
2933: ,okc_k_lines_b KLE
2934: WHERE TXD.asset_number = p_asset_number
2935: AND KLE.id = TXL.kle_id
2936: AND TXL.id = TXD.tal_id )

Line 3097: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,

3093: -- Version : 1.0
3094: -- End of Commnets
3095: PROCEDURE Validate_asset_tax_book(x_return_status OUT NOCOPY VARCHAR2,
3096: p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE,
3097: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,
3098: p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) IS
3099: ln_asset_lines_dtls NUMBER := 0;
3100: CURSOR c_asset_lines_dtls_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE,
3101: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,

Line 3101: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,

3097: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,
3098: p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) IS
3099: ln_asset_lines_dtls NUMBER := 0;
3100: CURSOR c_asset_lines_dtls_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE,
3101: p_tax_book OKL_TXD_ASSETS_B.TAX_BOOK%TYPE,
3102: p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) is
3103: SELECT 1
3104: --FROM DUAL
3105: --WHERE EXISTS (SELECT '1'

Line 3106: FROM OKL_TXD_ASSETS_B txd,

3102: p_tal_id OKL_TXL_ASSETS_B.ID%TYPE) is
3103: SELECT 1
3104: --FROM DUAL
3105: --WHERE EXISTS (SELECT '1'
3106: FROM OKL_TXD_ASSETS_B txd,
3107: OKL_TXL_ASSETS_B txl
3108: WHERE txl.asset_number = p_asset_number
3109: AND txl.asset_number = txd.asset_number
3110: AND txl.tal_type IN ('CFA','CIB','CRB','CRL','CSP','CRV')

Line 10620: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when

10616: END IF;
10617:
10618: --Bug# 5530990
10619: -- Update Original Cost and Depreciation Cost in
10620: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when
10621: -- Add on line is added
10622: update_asset_cost(p_api_version => p_api_version,
10623: p_init_msg_list => p_init_msg_list,
10624: x_return_status => x_return_status,

Line 10867: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when

10863: END IF;
10864:
10865: --Bug# 5530990
10866: -- Update Original Cost and Depreciation Cost in
10867: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when
10868: -- Add on line is updated
10869: update_asset_cost(p_api_version => p_api_version,
10870: p_init_msg_list => p_init_msg_list,
10871: x_return_status => x_return_status,

Line 11102: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when

11098: END IF;
11099:
11100: --Bug# 5530990
11101: -- Update Original Cost and Depreciation Cost in
11102: -- OKL_TXL_ASSETS_B and OKL_TXD_ASSETS_B when
11103: -- Add on line is deleted
11104: update_asset_cost(p_api_version => p_api_version,
11105: p_init_msg_list => p_init_msg_list,
11106: x_return_status => x_return_status,

Line 12739: from okl_txd_assets_b txdb

12735: --cursor to get all the tax books
12736: CURSOR l_taxbook_csr(p_tal_id in number) is
12737: select txdb.tax_book,
12738: txdb.id
12739: from okl_txd_assets_b txdb
12740: where txdb.tal_id = p_tal_id;
12741:
12742: l_taxbook_rec l_taxbook_csr%ROWTYPE;
12743:

Line 12818: l_mg_txd_id okl_txd_assets_b.id%TYPE;

12814: from fa_additions
12815: where asset_id = p_asset_id;
12816:
12817: l_asset_number fa_additions.asset_number%TYPE;
12818: l_mg_txd_id okl_txd_assets_b.id%TYPE;
12819: --Bug# 3631094
12820:
12821: --Bug# 3783518 :
12822: CURSOR l_chk_rbk_csr (p_chr_id in NUMBER) is

Line 13428: --update okl_txd_Assets_b

13424: RAISE OKL_API.G_EXCEPTION_ERROR;
13425: END IF;
13426:
13427: If l_nbv is NOT NULL then
13428: --update okl_txd_Assets_b
13429: l_txdv_rec.id := l_taxbook_rec.id;
13430: l_txdv_rec.cost := l_nbv;
13431: OKL_TXD_ASSETS_PUB.UPDATE_TXD_ASSET_DEF
13432: (

Line 15282: ,okl_txd_assets_b TXD

15278: SELECT '1'
15279: FROM okl_asset_returns_all_b KAR
15280: WHERE KAR.kle_id IN (SELECT KLE.cle_id
15281: FROM okl_txl_assets_b TXL
15282: ,okl_txd_assets_b TXD
15283: ,okc_k_lines_b KLE
15284: WHERE TXD.asset_number = p_asset_number
15285: AND KLE.id = TXL.kle_id
15286: AND TXL.id = TXD.tal_id )

Line 19000: -- Update Tax Book details - okl_txd_assets_b

18996: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18997: RAISE OKL_API.G_EXCEPTION_ERROR;
18998: END IF;
18999: --akrangan Bug# 5362977 start
19000: -- Update Tax Book details - okl_txd_assets_b
19001: update_asset_line_details(p_api_version => p_api_version,
19002: p_init_msg_list => p_init_msg_list,
19003: x_return_status => x_return_status,
19004: x_msg_count => x_msg_count,

Line 19905: -- Update Tax Book details - okl_txd_assets_b

19901: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19902: RAISE OKL_API.G_EXCEPTION_ERROR;
19903: END IF;
19904: --akrangan Bug# 5362977 start
19905: -- Update Tax Book details - okl_txd_assets_b
19906: update_asset_line_details(p_api_version => p_api_version,
19907: p_init_msg_list => p_init_msg_list,
19908: x_return_status => x_return_status,
19909: x_msg_count => x_msg_count,

Line 20744: -- Update Tax Book details - okl_txd_assets_b

20740: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20741: RAISE OKL_API.G_EXCEPTION_ERROR;
20742: END IF;
20743: --Bug# 5176649 start
20744: -- Update Tax Book details - okl_txd_assets_b
20745: update_asset_line_details(p_api_version => p_api_version,
20746: p_init_msg_list => p_init_msg_list,
20747: x_return_status => x_return_status,
20748: x_msg_count => x_msg_count,