APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on OKX_ASSETS_V

Line 896: FROM OKX_ASSETS_V

892: AND okiv.object1_id1=oiiv.instance_id;
893: /* this cursor retrives the total quantity for the asset*/
894: CURSOR get_qty_csr(p_asset_number IN VARCHAR2) IS
895: SELECT current_units quantity
896: FROM OKX_ASSETS_V
897: WHERE asset_number = p_asset_number;
898:
899: BEGIN
900: x_tif_rec := p_tif_rec;

Line 1769: FROM OKX_ASSETS_V

1765: l_msg_tbl msg_tbl_type;
1766: /* this cursor retrives the total quantity for the asset*/
1767: CURSOR get_qty_csr(p_asset_number IN VARCHAR2) IS
1768: SELECT current_units quantity
1769: FROM OKX_ASSETS_V
1770: WHERE asset_number = p_asset_number;
1771: BEGIN
1772: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1773: IF(p_tif_tbl.COUNT>0)THEN