The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT a.id,
a.SPLIT_PERCENT
FROM okl_txd_assets_v a
WHERE TAL_ID = p_tal_id
;
SELECT ORIGINAL_COST,
CURRENT_UNITS
FROM okl_txl_assets_b
WHERE id = p_tal_id
;
Okl_Asd_Pvt.update_row(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_asdv_rec,
x_asdv_rec);
SELECT NVL(SUM(SPLIT_PERCENT),0)
FROM okl_txd_assets_v
WHERE TAL_ID = p_tal_id
;
SELECT asset_number
FROM okl_txd_assets_v
WHERE TAL_ID = p_tal_id
GROUP BY asset_number
HAVING COUNT(1) > 1
;
SELECT asset_number
FROM okl_txd_assets_v
WHERE id = p_asd_id;
SELECT 'Y'
FROM okx_assets_v okx
WHERE okx.asset_number = p_asset_number;
SELECT 'Y'
FROM okl_k_lines_full_v kle,
okc_line_styles_b lse
WHERE kle.name = p_asset_number
AND kle.lse_id = lse.id
AND lse.lty_code = 'FIXED_ASSET';
SELECT 'Y'
FROM okl_txl_assets_b txl
WHERE txl.asset_number = p_asset_number
AND txl.tal_type IN ('ALI','CRB'); --only transactions apart from split which create a new line
SELECT inventory_item_id
FROM okl_txd_assets_v
WHERE TAL_ID = p_tal_id
GROUP BY inventory_item_id
HAVING COUNT(1) > 1
;
SELECT i.name
FROM okx_system_items_v i
WHERE i.ID1 = p_inventory_item_id
--group by i.name
;
SELECT cleb.dnz_chr_id
,cleb.id cle_id
,trxa.date_trans_occurred
FROM okl_trx_assets trxa
,okl_txl_assets_b txla
,okc_k_lines_b cleb
,okc_line_styles_b lseb
WHERE txla.kle_id = cleb.id
AND cleb.lse_id = lseb.id
AND lseb.lty_code = 'FIXED_ASSET'
AND txla.tal_type = 'ALI'
AND txla.tas_id = trxa.id
AND trxa.tsu_code = 'ENTERED'
AND txla.id = p_tal_id;
Okl_Asd_Pvt.insert_row(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_asdv_rec,
--p_asdv_tbl(i),
x_asdv_tbl(i));
PROCEDURE update_split_asset_comp(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_asdv_tbl IN advv_tbl_type,
x_asdv_tbl OUT NOCOPY advv_tbl_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'update_split_asset_comp';
SAVEPOINT update_split_asset_comp_pvt;
Okl_Asd_Pvt.update_row(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
l_asdv_rec,
--p_asdv_tbl(i),
x_asdv_tbl(i));
ROLLBACK TO update_split_asset_comp_pvt;
ROLLBACK TO update_split_asset_comp_pvt;
ROLLBACK TO update_split_asset_comp_pvt;
END update_split_asset_comp;
PROCEDURE delete_split_asset_comp(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_asdv_tbl IN advv_tbl_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'delete_split_asset_comp';
SAVEPOINT delete_split_asset_comp_pvt;
Okl_Asd_Pvt.delete_row(p_api_version,
p_init_msg_list,
x_return_status,
x_msg_count,
x_msg_data,
p_asdv_tbl);
ROLLBACK TO delete_split_asset_comp_pvt;
ROLLBACK TO delete_split_asset_comp_pvt;
ROLLBACK TO delete_split_asset_comp_pvt;
END delete_split_asset_comp;
SELECT NVL(SUM(SPLIT_PERCENT),0)
FROM okl_txd_assets_v
WHERE TAL_ID = p_tal_id
;
SELECT cle.cle_id
FROM okc_k_lines_b cle,
okl_txl_assets_b tal
WHERE cle.id = tal.kle_id
AND tal.id = p_tal_id;
SELECT cleb.dnz_chr_id
,cleb.cle_id cle_id
,trxa.date_trans_occurred
FROM okl_trx_assets trxa
,okl_txl_assets_b txla
,okc_k_lines_b cleb
,okc_line_styles_b lseb
WHERE txla.kle_id = cleb.id
AND cleb.lse_id = lseb.id
AND lseb.lty_code = 'FIXED_ASSET'
AND txla.tal_type = 'ALI'
AND txla.tas_id = trxa.id
AND trxa.tsu_code = 'ENTERED'
AND txla.id = p_tal_id;