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_TXD_ASSETS_B

Line 2578: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b

2574: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2575: RAISE process_error;
2576: END IF;
2577:
2578: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b
2579: IF p_book_rec.book_class = 'TAX' THEN
2580: lp_adpv_rec.tal_id := lx_tlpv_rec.id;
2581: lp_adpv_rec.tax_book := p_book_rec.book_type_code;
2582: lp_adpv_rec.asset_number := p_book_rec.asset_number;

Line 2710: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b

2706: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2707: RAISE process_error;
2708: END IF;
2709:
2710: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b
2711: IF p_book_rec.book_class = 'TAX' THEN
2712: lp_adpv_rec.tal_id := lx_tlpv_rec.id;
2713: lp_adpv_rec.tax_book := p_book_rec.book_type_code;
2714: lp_adpv_rec.asset_number := p_book_rec.asset_number;

Line 2885: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b

2881: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2882: RAISE process_error;
2883: END IF;
2884:
2885: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b
2886: IF p_book_rec.book_class = 'TAX' THEN
2887: lp_adpv_rec.tal_id := lx_tlpv_rec.id;
2888: lp_adpv_rec.tax_book := p_book_rec.book_type_code;
2889: lp_adpv_rec.asset_number := p_book_rec.asset_number;

Line 3024: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b

3020: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3021: RAISE process_error;
3022: END IF;
3023:
3024: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b
3025: IF p_book_rec.book_class = 'TAX' THEN
3026: lp_adpv_rec.tal_id := lx_tlpv_rec.id;
3027: lp_adpv_rec.tax_book := p_book_rec.book_type_code;
3028: lp_adpv_rec.asset_number := p_book_rec.asset_number;

Line 3186: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b

3182: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3183: RAISE process_error;
3184: END IF;
3185:
3186: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b
3187: IF p_book_rec.book_class = 'TAX' THEN
3188: lp_adpv_rec.tal_id := lx_tlpv_rec.id;
3189: lp_adpv_rec.tax_book := p_book_rec.book_type_code;
3190: lp_adpv_rec.asset_number := p_book_rec.asset_number;

Line 3323: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b

3319: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3320: RAISE process_error;
3321: END IF;
3322:
3323: -- SECHAWLA 06-MAY-04 3578894 : If this book is a tax book, also create a row in okl_txd_assets_b
3324: IF p_book_rec.book_class = 'TAX' THEN
3325: lp_adpv_rec.tal_id := lx_tlpv_rec.id;
3326: lp_adpv_rec.tax_book := p_book_rec.book_type_code;
3327: lp_adpv_rec.asset_number := p_book_rec.asset_number;

Line 4794: OKL_TXD_ASSETS_B d -- SECHAWLA 27-FEB-05 4147143 : added

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:
4798: -- SECHAWLA 24-FEB-05 4147143 : new declarations

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'