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_AM_AMORTIZE_PVT dependencies on OKL_TXL_ASSETS_B

Line 4746: -- Divide Depreciation rate by 100 before updating in okl_txl_assets_b. Rate passed from the

4742: -- Version : 1.0
4743: -- History : SECHAWLA 07-FEB-03 Bug # 2789656
4744: -- Added a validation to prevent negative salvage value
4745: -- SECHAWLA 03-JUN-04 Bug # 3657624
4746: -- Divide Depreciation rate by 100 before updating in okl_txl_assets_b. Rate passed from the
4747: -- screen is a percentage
4748: -- SECHAWLA 24-FEB-05 Bug # 4147143
4749: -- sync up other transactions for an asset when a particular transaction is updated for an asset
4750: -- SECHAWLA 27-FEB-05 Bug # 4147143

Line 4793: FROM okl_txl_assets_b l, -- SECHAWLA 24-FEB-05 4147143 : changed view to base table

4789: -- This cursor returns the transaction line information from okl_txl_assets_v
4790: CURSOR l_lines_csr(p_id number) IS
4791: SELECT l.asset_number, l.hold_period_days, l.depreciate_yn, l.kle_id, l.tal_type,
4792: decode(d.tax_book,NULL,l.CORPORATE_BOOK,d.tax_book ) ASSET_BOOK
4793: FROM okl_txl_assets_b l, -- SECHAWLA 24-FEB-05 4147143 : changed view to base table
4794: OKL_TXD_ASSETS_B d -- SECHAWLA 27-FEB-05 4147143 : added
4795: WHERE l.id = p_id
4796: AND l.id = d.tal_id(+); -- SECHAWLA 27-FEB-05 4147143 : added
4797:

Line 4803: FROM okl_trx_assets h, okl_txl_assets_b l, OKL_TXD_ASSETS_B d

4799: -- get the first 2 transaction lines
4800: -- SECHAWLA 27-FEB-05 4147143 : added check for book and status
4801: CURSOR l_nodeplines_csr(cp_kle_id IN NUMBER, cp_book_type_code IN VARCHAR2) IS
4802: SELECT l.id, l.tas_id
4803: FROM okl_trx_assets h, okl_txl_assets_b l, OKL_TXD_ASSETS_B d
4804: WHERE l.kle_id = cp_kle_id
4805: AND l.tas_id = h.id
4806: AND h.tsu_code IN ( 'ENTERED','ERROR')
4807: AND l.tal_type IN ('AUF','AUT')

Line 4816: FROM okl_trx_assets hdr, okl_txl_assets_b line, OKL_TXD_ASSETS_B txd

4812: -- Get the 4th transaction
4813: -- SECHAWLA 27-FEB-05 4147143 : added check for book and status
4814: CURSOR l_depstartline_csr(cp_kle_id IN NUMBER, cp_book_type_code IN VARCHAR2) IS
4815: SELECT hdr.id hdr_id ,line.id line_id
4816: FROM okl_trx_assets hdr, okl_txl_assets_b line, OKL_TXD_ASSETS_B txd
4817: WHERE line.kle_id = cp_kle_id
4818: AND line.tas_id = hdr.id
4819: AND hdr.tsu_code IN ( 'ENTERED','ERROR')
4820: AND tal_type = 'AUF'

Line 4830: FROM okl_trx_assets h, okl_txl_assets_b l, OKL_TXD_ASSETS_B d

4826: -- get the 3rd transaction header
4827: -- SECHAWLA 27-FEB-05 4147143 : added check for book and status
4828: CURSOR l_amortline_csr(cp_kle_id IN NUMBER, cp_book_type_code IN VARCHAR2) IS
4829: SELECT h.DATE_TRANS_OCCURRED
4830: FROM okl_trx_assets h, okl_txl_assets_b l, OKL_TXD_ASSETS_B d
4831: WHERE l.kle_id = cp_kle_id
4832: AND l.tas_id = h.id
4833: AND h.tsu_code IN ( 'ENTERED','ERROR')
4834: AND l.tal_type = 'AML'

Line 4911: -- in okl_txl_assets_b

4907:
4908: END IF;
4909:
4910: -- SECHAWLA 03-JUN-04 3657624 : depreciation rate needs to be divided by 100 before storing
4911: -- in okl_txl_assets_b
4912: IF lp_lines_temp_rec.deprn_rate IS NOT NULL AND lp_lines_temp_rec.deprn_rate <> OKL_API.G_MISS_NUM THEN
4913: lp_lines_temp_rec.deprn_rate := lp_lines_temp_rec.deprn_rate / 100;
4914: END IF;
4915: