APPS.OKL_SPLIT_ASSET_COMP_PVT dependencies on OKL_TXL_ASSETS_B

Line 33: l_oec okl_txl_assets_B.ORIGINAL_COST%TYPE;

29: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
30: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
31: l_id okl_txd_assets_B.ID%TYPE;
32: l_split_percent okl_txd_assets_B.SPLIT_PERCENT%TYPE;
33: l_oec okl_txl_assets_B.ORIGINAL_COST%TYPE;
34: l_units okl_txl_assets_B.CURRENT_UNITS%TYPE;
35: l_asdv_rec Okl_Asd_Pvt.asdv_rec_type;
36: x_asdv_rec Okl_Asd_Pvt.asdv_rec_type;
37:

Line 34: l_units okl_txl_assets_B.CURRENT_UNITS%TYPE;

30: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
31: l_id okl_txd_assets_B.ID%TYPE;
32: l_split_percent okl_txd_assets_B.SPLIT_PERCENT%TYPE;
33: l_oec okl_txl_assets_B.ORIGINAL_COST%TYPE;
34: l_units okl_txl_assets_B.CURRENT_UNITS%TYPE;
35: l_asdv_rec Okl_Asd_Pvt.asdv_rec_type;
36: x_asdv_rec Okl_Asd_Pvt.asdv_rec_type;
37:
38: --

Line 53: FROM okl_txl_assets_b

49: CURSOR c_org(p_tal_id NUMBER)
50: IS
51: SELECT ORIGINAL_COST,
52: CURRENT_UNITS
53: FROM okl_txl_assets_b
54: WHERE id = p_tal_id
55: ;
56:
57: BEGIN

Line 499: FROM okl_txl_assets_b txl

495:
496: --check for asset on create asset or rebook transaction
497: CURSOR asset_chk_curs3 (p_asset_number IN VARCHAR2) IS
498: SELECT 'Y'
499: FROM okl_txl_assets_b txl
500: WHERE txl.asset_number = p_asset_number
501: AND txl.tal_type IN ('ALI','CRB'); --only transactions apart from split which create a new line
502:
503: l_asset_exists VARCHAR2(1) DEFAULT 'N';

Line 782: ,okl_txl_assets_b txla

778: SELECT cleb.dnz_chr_id
779: ,cleb.id cle_id
780: ,trxa.date_trans_occurred
781: FROM okl_trx_assets trxa
782: ,okl_txl_assets_b txla
783: ,okc_k_lines_b cleb
784: ,okc_line_styles_b lseb
785: WHERE txla.kle_id = cleb.id
786: AND cleb.lse_id = lseb.id

Line 1251: okl_txl_assets_b tal

1247:
1248: CURSOR fin_ast_csr (p_tal_id IN NUMBER) IS
1249: SELECT cle.cle_id
1250: FROM okc_k_lines_b cle,
1251: okl_txl_assets_b tal
1252: WHERE cle.id = tal.kle_id
1253: AND tal.id = p_tal_id;
1254:
1255: l_cle_id okc_k_lines_b.id%TYPE;

Line 1270: ,okl_txl_assets_b txla

1266: SELECT cleb.dnz_chr_id
1267: ,cleb.cle_id cle_id
1268: ,trxa.date_trans_occurred
1269: FROM okl_trx_assets trxa
1270: ,okl_txl_assets_b txla
1271: ,okc_k_lines_b cleb
1272: ,okc_line_styles_b lseb
1273: WHERE txla.kle_id = cleb.id
1274: AND cleb.lse_id = lseb.id