APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on OKX_INSTALL_ITEMS_V

Line 857: FROM okc_k_items_v okiv,okx_install_items_v oiiv

853: AND ols.lty_code = 'INST_ITEM';
854: /* this cursor retrives the serial_number for the instance of the asset*/
855: CURSOR get_sno_csr(p_installbase_id IN NUMBER) IS
856: SELECT oiiv.serial_number sno
857: FROM okc_k_items_v okiv,okx_install_items_v oiiv
858: WHERE okiv.cle_id = p_installbase_id
859: AND okiv.object1_id1=oiiv.instance_id;
860: /* this cursor retrives the total quantity for the asset*/
861: CURSOR get_qty_csr(p_asset_number IN VARCHAR2) IS

Line 1780: FROM okc_k_items_v okiv,okx_install_items_v oiiv

1776: AND ols.lty_code = 'INST_ITEM';
1777: /* this cursor retrives the serial_number and quantity for the instance of the asset*/
1778: CURSOR get_sno_qty_csr(p_installbase_id IN NUMBER) IS
1779: SELECT oiiv.serial_number sno,oiiv.quantity qty
1780: FROM okc_k_items_v okiv,okx_install_items_v oiiv
1781: WHERE okiv.cle_id = p_installbase_id
1782: AND okiv.object1_id1=oiiv.instance_id;
1783: BEGIN
1784: x_return_status := OKC_API.G_RET_STS_SUCCESS;